If they are separated by a common delimiter, you can use the Data-'Text to
Columns...' feature.


--
Regards,
Dave


"BRyan" wrote:

I received an Excel document that has 2000 plus names and addresses, however
they put the name and address together in one cell and I need them in
seperate cells so I can sort on the address. Is there a way I can take the
information in one cell and move it to several different cells, without
having to cut and paste every one of the 2000 cells.