One way:
=RIGHT(A1,MATCH(" ",MID(A1,1+LEN(A1)-ROW(INDIRECT("1:"&LEN
(A1))),1),0)-1)&" "&LEFT(A1,FIND(" ",A1,FIND(" ",A1)+1))
Press ctrl/shift/enter, not just enter.
HTH
Jason
Atlanta, GA
-----Original Message-----
Not sure how the formula should read to swap first name
with last name in a
sheet. All names were entered using First name, Middle
initial and Last
name. Sometimes Middle name is used rather than
initial. Not sure how to
designate position of Last name. Thanks.
--
Alice.
.
|