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