zach3ZachPremium
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 |
|
 H2OuUp2Happy to be herePremium
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. |
|
|
|
zach3ZachPremium
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 |
|
H2OuUp2Happy to be herePremium
join:2002-03-15
Oklahoma City, OK | reply to zach3
You are welcome. |
|
