View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
walkerdayle
 
Posts: n/a
Default 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