Extracting Text in a string of text

[walkerdayle]

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

 

[RagDyeR]

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" <[email protected]>
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]

Thanks, I'll give it a try

 

[walkerdayle]

Thank you so very much. One more question, how can I do the same, bu
extracting the City only. For example, Bronx, NY 10451 or Whit
Plains, NY 10463? I've used the Left but it doesn't get the precis
name like White Plains.

Thank

 

[David Billigmeier]

Try:

=LEFT(A1,SEARCH(",",A1)-1)

 

[walkerdayle]

Thanks for all of your help :