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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming Worksheet Tabs? 18
How to interchange of any 2 pages? 0
Swap text 2
how to search vertically then count horizontally in excel 2
merge excel into word and email 1
VLOOKUP? SUMPRODUCT? not sure how to do this 4
vlookup / index / match? 5
Flattening Data 2

Top