dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
1
share rss forum feed


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

Re: [Excel] Hotmail Block List

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