Switching words within cells

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

Guest

Is it possible to switch the word order within a cell. For example, if I
have Alexander Todd in cell A1, can I change it to Todd Alexander? Thanks
for the help!
 
hi
=SUBSTITUTE(MID(A1,FIND(" ",A1)+1,255)&" "&LEFT(A1,FIND
(" ",A1)),"/"," & ")
Switch the cell address to your cell address
 
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 word order within cells 2
Not sure of formula help please 4
Populate cell with data from another worksheet 4
Macro not recognizing blank lines as blank 9
Cell transition 1
VLOOKUP 10
Simple Formula Trouble 3

Back
Top