change order of name in cell

Wookie

Board Regular
Joined
Mar 4, 2003
Messages
220
I have a file with peoples names in column A in format
Bloggs, Joe
Smith, John

I want in column B to have
Joe Bloggs
John Smith

any ideas?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good afternoon Wookie

If your column starts in row 1 and strictly follows the format you have indicated then something ike this should suffice :

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1) & LEFT(A1,FIND(",",A1)-1)

Just copy it to the bottom.

HTH

DominicB
 

Watch MrExcel Video

Forum statistics

Threads
1,114,398
Messages
5,547,722
Members
410,809
Latest member
pieter89
Top