View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.