Extract First Name Last name

[patneel]

Hi,

I have data stored as Last Name, First name but I want to get it now First Name Last Name (no comma)

Example-
Data-
Ho, Joseph zu-sien

Required Result-
Joseph zu-sien Ho


Also the lenghth of each name would be different so can not use fixed number to get required result.


Appreciate any help..

 

[patneel]

Thanks All ..

 

[Rick Rothstein]

Is this really worth discussing for there can be 0 to N spaces around the parts of the names and/or nothing after the comma? The +1 bit after FIND within REPLACE won't work as you may guess.

Ah, okay, I see... I was thinking too narrowly there. Thanks!

 

[Rick Rothstein]

If there is always a space after the comma...

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

otherwise...

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

As a result of an exchange I just had with Aladin, if you are considering using my formula approach, then you should use this version of the formula as it is far more robust than the other one that I posted...

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