Hi,
I am a bit stuck and was wondering if anyone has any ideas.
I have an extract from Exchange that has data similar to this..lots of rows but need a formula that searches each row for "*newmail.com" and appears in the NEWMAIL column (C):
<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2606;">
<col width="186" style="width: 140pt; mso-width-source: userset; mso-width-alt: 6493;">
<col width="293" style="width: 220pt; mso-width-source: userset; mso-width-alt: 10240;">
<col width="134" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4677;">
<col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5259;">
<col width="159" style="width: 119pt; mso-width-source: userset; mso-width-alt: 5538;">
<col width="95" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3328;">
<tbody>
</tbody>
Any Ideas ?
I am a bit stuck and was wondering if anyone has any ideas.
I have an extract from Exchange that has data similar to this..lots of rows but need a formula that searches each row for "*newmail.com" and appears in the NEWMAIL column (C):
NAME | MYMAIL | NEWMAIL | Mail data1 | Mail data2 | Mail data 3 | >have about 50 |
Bob Smith | bob.smith@mymail.com | <Need to return the Newmail address here> | bobs@othermail.com | bobs@newmail.com | boby@hotmail.com | |
Larry Smith | Larry.smith@mymail.com | <Need to return the Newmail address here> | larrys@somelese.com | larry@hotmail.com | Larry@newmail.com | |
Sandy Smith | Sandy.Smith@mymail.com | <Need to return the Newmail address here> | sand@hotmail.com | sandyb@outlook.com | sandyb@newmail.com |
Any Ideas ?