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:confused:


--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=494602

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:confused:


--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile:
http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=494602

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

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

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

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