Question about Flipping Names in same cell
Hi
This will not work if A1 contains a middlename.
=RIGHT(A1,SEARCH(" ",A1)) & " " & LEFT(A1,SEARCH(" ",A1)-1)
Regards,
Per
"Catherine Damiani" skrev i meddelelsen ...
say i have John Smith in A1 and want it to be Smith John in A2, what would
the formula look like that would be in A2?
thank you!!!
|