ExcelBanter - Text Strings Swap

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Text Strings Swap (https://www.excelbanter.com/excel-worksheet-functions/57717-text-strings-swap.html)

Mzansi

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

Bob Phillips

Text Strings Swap

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

--

HTH

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

"Mzansi" wrote in message
...
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

All times are GMT +1. The time now is 08:15 PM.