Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text in a string of text
Happy Holidays to All! How do I extract a concatenated field so I have exactly what I need. I've used the Left and Right functions, but I need to extract more precisely without having to guess the number of characters. For example: New York, NY 10019 I want to extract out the "NY" or the state. How do I do that given I may have multiple city and states? Thanks for any help -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=494602 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text in a string of text
This will give you the 2 characters (state) that follows the comma:
=MID(A1,FIND(",",A1)+2,2) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "walkerdayle" wrote in message ... Happy Holidays to All! How do I extract a concatenated field so I have exactly what I need. I've used the Left and Right functions, but I need to extract more precisely without having to guess the number of characters. For example: New York, NY 10019 I want to extract out the "NY" or the state. How do I do that given I may have multiple city and states? Thanks for any help -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=494602 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text in a string of text
Thanks, I'll give it a try -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=494602 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text in a string of text
Thank you so very much. One more question, how can I do the same, but extracting the City only. For example, Bronx, NY 10451 or White Plains, NY 10463? I've used the Left but it doesn't get the precise name like White Plains. Thanks -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=494602 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text in a string of text
Try:
=LEFT(A1,SEARCH(",",A1)-1) -- Regards, Dave "walkerdayle" wrote: Thank you so very much. One more question, how can I do the same, but extracting the City only. For example, Bronx, NY 10451 or White Plains, NY 10463? I've used the Left but it doesn't get the precise name like White Plains. Thanks -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=494602 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text in a string of text
Thanks for all of your help:) :) -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=494602 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I look up a number within a string of text | Excel Worksheet Functions | |||
Countif function for instances of text string contained | Excel Worksheet Functions | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Extracting Surname from within a text string | Excel Worksheet Functions | |||
Formating a text string? | Excel Discussion (Misc queries) |