I need to swap last name, first name in a cell to first name last Need formula
W Wink May 27, 2006 #1 I need to swap last name, first name in a cell to first name last Need formula
B Bob Phillips May 27, 2006 #3 =RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1) -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct)
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1) -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct)
B Bob Phillips May 27, 2006 #4 A bit shorter alternative =MID(A1&" "&A1, FIND(",",A1)+2,LEN(A1)-1) -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct)
A bit shorter alternative =MID(A1&" "&A1, FIND(",",A1)+2,LEN(A1)-1) -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct)
