1. Select the column.
2. Go to Data Text to columns
3. Select "Delimited" and select a comma as your
delimiter.
4. Switch the columns around.
HTH
Jason
Atlanta, GA
-----Original Message-----
I have a database imported into excel, column a has
surname and Christin
names seperated by a comma, ie Adams,John want to
extract these into another
column as John Adams
.
|