View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default pulling out info. seperated by a comma

Select the column and do Data=Text to Columns and select the comma as the
delimiter.

--
Regards,
Tom Ogilvy

"scrabtree" wrote in message
...
I have an address in one cell. I would like to seperate
the address into multiple cells at the point of each
comma. This way, for example, the state, and the city
would be in two cells instead of one.?????