Switching word order within cells

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

Guest

Is it possible to switch the order of words within cells, for example if I
have Alexander Todd can I change it to be Todd Alexander? Thanks for the
help!
 
Try this

=MID(A1,FIND(" ",A1)+1,72)&" "&LEFT(A1,FIND(" ",A1))

It will work as long as the text has two words separated by a spac
 
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

Switching words within cells 1
Switching words within cells 1
Macro not recognizing blank lines as blank 9
Not sure of formula help please 4
Simple Formula Trouble 3
SORTING A COLUMN BY DATE 6
Cell transition 1
VLOOKUP 10

Back
Top