Text Strings Swap

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell with "Joe Blogg" and I want to swap it to"Blogg Joe"... Is
there any formular I can Use.
 
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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
merge excel into word and email 1
VLOOKUP? SUMPRODUCT? not sure how to do this 4
how to search vertically then count horizontally in excel 2
vlookup / index / match? 5
Text Functions 2
Count occurances of a name over previous 12 months 4
Columns Counting Function Reqd 4

Back
Top