Question about Flipping Names in same cell
This will work as long as there is no middle initial or middle name and as
long as the first name is never made up of two names (such as Mary Anne)...
=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))
--
Rick (MVP - Excel)
"Catherine Damiani" wrote in message ...
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!!!
|