pulling out info. seperated by a comma
 

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

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