Filtering columns to show specific text only

[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
====================================

 

[JE McGimpsey]

Filters don't change displayed data. You could use a helper column:

=LEFT(MID(A1, FIND("SMTP:", A1), 255), FIND("%", MID(A1,
FIND("SMTP:", A1), 255))-1)

 

[Curtis Fray]

Brilliant. Thanks for the quick reply. That's sorted it!

Curtis.

========================