View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike M.
 
Posts: n/a
Default How do I delete text to right of a comma in a range of cells?

I have a long list of addresses and need to separate out the city and state,
which got merged all into one cell. Need to import data into Streets and
Trips and want to delete all city and state info out of the address cells.
Please assist.

Mike