Oh well!

Where's your REGEX solution? I know I've seen it at least once.

Biff

"Ron Rosenfeld" wrote in message
...
On Thu, 16 Mar 2006 16:39:40 -0500, "Biff" wrote:

This seems to work:

=TRIM(RIGHT(SUBSTITUTE(LEFT(A1&" ",FIND(" ",A1&" ",FIND("@",A1&" "))-1),"
",REPT(" ",LEN(A1))),LEN(A1)))

Biff

It will fail if the string happens to start with a dot <..

It also gives an erroneous result with:

"It's too bad that John Jones is no longer with us"

and various other legal email configurations.






--ron