Thread: text find
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choice[_2_] choice[_2_] is offline
external usenet poster
 
Posts: 84
Default text find

i have:
"A1" San Diego, CA 94588
"A2" Seattle, WA 96811
"A3" Honolulu, HI 96822
etc...

I need for the City to be in one cell, State in the other, and ZIP in another
"A1" San Diego "B1" CA "C1" 94588
i tried doing a find replace, based on the comma, but i cant seem to get it
right.

please help

Thank you