Naming Formula: Last, First to First Last

[njexpress9]

Attempting to modify a list of names. Currently they are last name, first but I want to compare to another list that is first name last.

Ex:

Billingsley, George

formula to change to:

George Billingsley (no comma)

Any help would be appreciated.

Thanks,
NJEXPRES9

[NBVC]

Try:

=Mid(A1,Find(",",A1)+2,255)&" "&Left(A1,Find(",",A1)-1)

[Paul]

Hi NJ,

If your name is in A1, then in B1 use:

=MID(A1,FIND(",",A1)+2,255)&" "&LEFT(A1,FIND(",",A1)-1)

[Richard Schollar]

An alternative:


=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1)-1)

Richard

[DonkeyOte]

very clever Mr S ! :bow:

[Richard Schollar]

Another one I owe to Barry. Sigh...