How do you truncate a text string?
- From: dailygluttony <dailygluttony.25e7sy_1143571503.8005@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Mar 2006 12:40:11 -0600
Hello,
I was wondering if there's a function that allows me to chop characters
of a fixed length off of text strings of varying lengths. For example,
if I have the following strings:
12345-ABC
123456-DEF
I want to be able to cut off the "-ABC" or the "-DEF" and be left with
12345
123456
Normally, I would simply use an =LEFT to capture the part I need, but
since the part before the dash is of varying lengths, I'm not sure how
to do this. Any help would be appreciated.
Thanks!
--
dailygluttony
------------------------------------------------------------------------
dailygluttony's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32907
View this thread: http://www.excelforum.com/showthread.php?threadid=527259
.
- Follow-Ups:
- Re: How do you truncate a text string?
- From: Peo Sjoblom
- Re: How do you truncate a text string?
- Prev by Date: Re: Round current time
- Next by Date: Excel kept on asking to save file every time I jump from one sheet to another!
- Previous by thread: Re: Round current time
- Next by thread: Re: How do you truncate a text string?
- Index(es):
Relevant Pages
|
