Text Strings Swap

I have a cell with "Joe Blogg" and I want to swap it to"Blogg Joe"... Is
there any formular I can Use.
--
Once Beaten, Twice Shy

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

--

HTH

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


"Mzansi" <Mzansi@discussions.microsoft.com> wrote in message
news:4A773891-F30F-4750-B017-AB5AE85E09F2@microsoft.com...
> I have a cell with "Joe Blogg" and I want to swap it to"Blogg Joe"... Is
> there any formular I can Use.
> --
> Once Beaten, Twice Shy