A Adam Morgan Nov 1, 2003 #1 Can someone please help me create a formula that will do the following... change a cell from: doe,john to john,doe
Can someone please help me create a formula that will do the following... change a cell from: doe,john to john,doe
J JMay Nov 1, 2003 #2 Try: =MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1)+1)&", "&LEFT(A1,FIND(",",A1)-1) with a1 = Doe, John HTH
Try: =MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1)+1)&", "&LEFT(A1,FIND(",",A1)-1) with a1 = Doe, John HTH
S shockley Nov 1, 2003 #3 Or, you might like: =RIGHT(A1, LEN(A1)-FIND(",",A1,1))&","&LEFT(A1,FIND(",",A1,1)-1) (A1 contains john,doe) HTH, Shockley
Or, you might like: =RIGHT(A1, LEN(A1)-FIND(",",A1,1))&","&LEFT(A1,FIND(",",A1,1)-1) (A1 contains john,doe) HTH, Shockley
