=MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,255)&" "
&LEFT(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
","")))))

and copy down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"oldLearner57" wrote in message
...
hi community

i have these data :

A B C

1 A. Yamamoto

2 Q. C. Carver

3 O. Sanchex

4 F. X. Layman

how can i extract and have it as in B column as:

A B C


1 A. Yamamoto Yamamoto A.

2 Q. C. Carver Carver Q. C.

3 O. Sanchex Sanchex O.

4 F. X. Layman Layman F. X.

thanks community for the assistance

:)


--
oldLearner57