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