Are you okay with that, or do you want help?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steven Deng" wrote in message
news:UYRhd.97175$nl.83171@pd7tw3no...
Sweet ! Bob, Now I need to do is to modify it a little bit to get "*" and
"," in place!

Sincerely
Steven Deng


"Bob Phillips" wrote in message
...
Steven,

Try this worksheet formula

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

--