M Mike F Aug 21, 2009 #1 I have a cell with the name Doe Jane. Is there a way I can invert the information in the cell to read 'Jane Doe'?
I have a cell with the name Doe Jane. Is there a way I can invert the information in the cell to read 'Jane Doe'?
L Luke M Aug 21, 2009 #2 Something like this: =MID(A2,FIND(" ",A2)+1,255)&" "&LEFT(A2,FIND(" ",A2)-1)
J Jacob Skaria Aug 21, 2009 #3 Try =MID(A1,FIND(" ",A1),99)& " " & LEFT(A1,FIND(" ",A1)) If this post helps click Yes
L L. Howard Kittle Aug 21, 2009 #4 Hi Mike, =MID(A1,FIND(" ",A1)+1,10)&" "&LEFT(A1,FIND(" ",A1)) Will work for simple names per your example. Goes nuts with names like Du Pont James or St James Susan. (Change the 10 to a larger number if first name exceeds 10 characters) HTH Regards, Howard
Hi Mike, =MID(A1,FIND(" ",A1)+1,10)&" "&LEFT(A1,FIND(" ",A1)) Will work for simple names per your example. Goes nuts with names like Du Pont James or St James Susan. (Change the 10 to a larger number if first name exceeds 10 characters) HTH Regards, Howard
