Text Strings Swap

M

Mzansi

I have a cell with "Joe Blogg" and I want to swap it to"Blogg Joe"... Is
there any formular I can Use.
 
B

Bob Phillips

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top