need to remove garbage from eml

[r3x3]

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.

<CourrielsDataSet xmlns="http://tempuri.org/CourrielsDataSet.xsd">
<Courriels>
<AdresseCourriel>pxplx@videotron.ca</AdresseCourriel>
</Courriels>
</CourrielsDataSet>

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

[zeddy]

Hi

Can you post an example in an Excel file?

zeddy

[r3x3]

i should have said removing the crude form xml

[zeddy]

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