Thank you, Rick!
--
Cynthia


"Rick Rothstein (MVP - VB)" wrote:

=MID(A1,FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1,"
","")))),255)

=IF(SUMPRODUCT(--ISNUMBER(FIND(MID(C1,ROW(INDIRECT("c1:A"&LEN(C1))) ,1),"0123456789")))0,SUBSTITUTE(A1,"
",",",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),A1)

I figured I should point this out, just in case... on my newsreader, the
above two formulas got word wrapped at a blank space character making it
hard to see that there is a blank space character between the quote marks.

Rick