G Guest Nov 14, 2003 #1 In a cell I have "First Name Last Name" I would like to change this in the cell to "Last Name, First Name".
In a cell I have "First Name Last Name" I would like to change this in the cell to "Last Name, First Name".
C Chip Pearson Nov 14, 2003 #2 Use the following formula, where A1 contains the name. =MID(A1,FIND(" ",A1)+1,LEN(A1))&", "&LEFT(A1,FIND(" ",A1)-1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Use the following formula, where A1 contains the name. =MID(A1,FIND(" ",A1)+1,LEN(A1))&", "&LEFT(A1,FIND(" ",A1)-1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
