dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
378
share rss forum feed

zach3
Zach
Premium
join:2000-05-04
Saint Louis, MO

[Excel] Hotmail Block List

Hello,

I have an Excel 2003 list of email addresses that I want to sort less everything in front of the @ sign.

contact-70326@freshstarfinderz.corn

How do I remove the "contact-70326" or anything else that might be in front of the @ sign???

I am working on my Block list for Hotmail.com and they no longer allow you to build the list using say the work "contact" you must include the @ sign plus everything after the @ sign.

Any assistance would be appreciated.

Thanks,

Zach



H2OuUp2
Happy to be here
Premium
join:2002-03-15
Oklahoma City, OK

Lets say your email address start in cell C1.

You could put the formula in D1 and it would give you what you are looking for.

=MID(C1,FIND("@",C1),LEN(C1))
--
He is no fool who gives up what he cannot keep, to gain what he cannot lose. - Jim Elliot


PS if you want to the results to a different area, copy the formula down for each row of email address, then copy and paste the results as Values only.


zach3
Zach
Premium
join:2000-05-04
Saint Louis, MO

H2,

Works like a champ!! That is a formula that I will put in my list of keepers!!

Thank You Very Much

Zach



H2OuUp2
Happy to be here
Premium
join:2002-03-15
Oklahoma City, OK
reply to zach3

You are welcome.