Need to change First Name Last Name to Last Name, First Name. Can anyone help?

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Oeldere

Well-known Member
Joined
Dec 29, 2011
Messages
2,213
use text to column on column A.

after that:

c1=b1&", "&a1

and drag down.

copy column C and paste special => values in e.g. column D.

Then you can delete column A, B and C.
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

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

Watch MrExcel Video

Forum statistics

Threads
1,109,523
Messages
5,529,333
Members
409,863
Latest member
stacy09
Top