I want to switch a person's first and last name in a cell, what should I do?
N Niek Otten Jun 17, 2008 #2 Look here: http://www.cpearson.com/excel/FirstLast.htm -- Kind regards, Niek Otten Microsoft MVP - Excel |I want to switch a person's first and last name in a cell, what should I do?
Look here: http://www.cpearson.com/excel/FirstLast.htm -- Kind regards, Niek Otten Microsoft MVP - Excel |I want to switch a person's first and last name in a cell, what should I do?
G Gary''s Student Jun 17, 2008 #3 With James Ravenswood in A1 =REPLACE(A1&" "&LEFT(A1,FIND(" ",A1)),1,FIND(" ",A1),"") displays Ravenswood James
With James Ravenswood in A1 =REPLACE(A1&" "&LEFT(A1,FIND(" ",A1)),1,FIND(" ",A1),"") displays Ravenswood James
F FSt1 Jun 17, 2008 #4 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
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
