pulling out info. seperated by a comma

S

scrabtree

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.?????
 
T

Tom Ogilvy

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