need to remove garbage from eml

Topic

New Reply

data base points to a email fild that was written in xml that generates ;a lot of garbage. here is a copy of the extraction.

pxplx@videotron.ca

How can each email address so the case above would give pxplx@videotron.ca

Reply | Quote

Replies

Hi

Can you post an example in an Excel file?

zeddy

Reply | Quote

i should have said removing the crude form xml

Reply | Quote

Hi

See attached file.
I placed a formula in column B which looks for the @ char found in an email address.
In column C, I then put a formula that extracts the email address.
(The find formula uses a dummy char ® which is unlikely to be found in the source)

zeddy

Reply | Quote