G Guest Apr 6, 2005 #1 Joe Brown is the text in a cell. Is there a worksheet function that I can turn this into Brown, Joe in another cell.
Joe Brown is the text in a cell. Is there a worksheet function that I can turn this into Brown, Joe in another cell.
N Niek Otten Apr 6, 2005 #2 See http://www.cpearson.com/excel/FirstLast.htm -- Kind Regards, Niek Otten Microsoft MVP - Excel
A Alan Perkins Apr 6, 2005 #3 One way: Assuming you have the name in cell A1... =RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)
One way: Assuming you have the name in cell A1... =RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)
D Domenic Apr 6, 2005 #4 Assuming no middle initials, try... =RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1) Hope this helps!
Assuming no middle initials, try... =RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1) Hope this helps!
