have a look at
datatext to columnspretty self explanatory

--
Don Guillett
SalesAid Software

"Cheri" wrote in message
...
I have 2 lines of data in one column i.e., name and social security number.
Is there a way to automatically make that information into two columns.

Cheri