I need to swap last name, first name in a cell to first name last
 

I need to swap last name, first name in a cell to first name last
Need formula

I need to swap last name, first name in a cell to first name last
 

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

HTH
--
AP

"Wink" a écrit dans le message de news:
...
I need to swap last name, first name in a cell to first name last
Need formula

I need to swap last name, first name in a cell to first name last
 

=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)

"Wink" wrote in message
...
I need to swap last name, first name in a cell to first name last
Need formula

I need to swap last name, first name in a cell to first name last
 

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)

"Bob Phillips" wrote in message
...


--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Wink" wrote in message
...
I need to swap last name, first name in a cell to first name last
Need formula