Need a formula to remove an email address from a long string of text.

Teethless mama - how can i make it so it takes out everything else other than the emaila addresses?

No problem....

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),FIND("@",SUBSTITUTE(A1," ",REPT(" ",99)))-50,99))

thanks also, on a related note. i have characters in there i don't want, there are loads of commas, quote marks and a SMTP. how can i remove them? (doesn't have to be in 1 formula)