C
Curtis Fray
Hi,
I have a column in Excel XP with entries such as the two below:
CCMAIL:Simpson, Bart at
Manor-House%MS:NETWORK/EXCHANGE/BSIMPSON%SMTP:[email protected]%X400:c=GB;a=NHS;p=NHS
A AND O HN;o=NHS HEALTHCARE TR;s=Simpson;g=Bart;
SMTP:[email protected]%X400:c=GB;a=NHS;p=NHS A AND O HN;o=NHS
HEALTHCARE TR;s=Simpson;g=Lisa;%CCMAIL:Simpson, Lisa at
Manor-House%MS:NETWORK/EXCHANGE/LSIMPSON
What I need to do is filter these so only everything between <SMTP:> and the
first <%> symbol after that is shown. For example, the above two need to
become:
SMTP:[email protected]
SMTP:[email protected]
Can anyone tell me how to go about this?
Thanks,
Curtis.
====================================
When replying by email please remove the X
====================================
I have a column in Excel XP with entries such as the two below:
CCMAIL:Simpson, Bart at
Manor-House%MS:NETWORK/EXCHANGE/BSIMPSON%SMTP:[email protected]%X400:c=GB;a=NHS;p=NHS
A AND O HN;o=NHS HEALTHCARE TR;s=Simpson;g=Bart;
SMTP:[email protected]%X400:c=GB;a=NHS;p=NHS A AND O HN;o=NHS
HEALTHCARE TR;s=Simpson;g=Lisa;%CCMAIL:Simpson, Lisa at
Manor-House%MS:NETWORK/EXCHANGE/LSIMPSON
What I need to do is filter these so only everything between <SMTP:> and the
first <%> symbol after that is shown. For example, the above two need to
become:
SMTP:[email protected]
SMTP:[email protected]
Can anyone tell me how to go about this?
Thanks,
Curtis.
====================================
When replying by email please remove the X
====================================