Combine names seperated by comma

B

bbc1

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
 
G

Gordon

Jason said:
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.
Click to expand...

And then concatenate, as the OP wants both in the same column!
 
J

Jason Morin

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
 
D

David

=?Utf-8?B?YmJjMQ==?= wrote
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
Click to expand...

Put this in the target column where imported names start in ColA, Row2
=RIGHT($A2,LEN($A2)-FIND(" ",$A2))&" "&LEFT($A2,FIND(",",$A2)-1)
Adjust $A2 to your source
 
Top