how do i switch the first and last name in a cell?

G

Gary''s Student

With James Ravenswood in A1
=REPLACE(A1&" "&LEFT(A1,FIND(" ",A1)),1,FIND(" ",A1),"")
displays
Ravenswood James
 
F

FSt1

hi
an example of your names would have been nice. are the seperated by comma?
if so try this.....
=MID(A6,FIND(",",A6)+2,255)& " "&LEFT(A6,FIND(",",A6)-1)
if not, post some examples of what you are trying to reverse.

Regards
FSt1
 

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

Fonts and Cells 4
How do I change name in single cell from last, first to first last 2
Why doesn't autofill work in Excel? 1
Can I switch the order of text entries in a cell? 3
Reversing first and last names in one cell 5
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
How do I switch the contents of 2 cells? 1
How do I switch the contents of 2 cells in Excel? 1

Top