I think your solution is best.
On Wed, Dec 23, 2009 at 3:18 PM, Dilip Pandey wrote:
> Dear Gobet,
>
> Use following formula in the column B and drag it down.
>
> =RIGHT(A2,LEN(A2)-FIND("@",A2)+1)
>
> solved workbook is also attached. Thanks
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
suppose in sheet1 range a1 u have a value like
a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com
a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com
ab...@gmail.com ab...@gmail.com ab...@gmail.com ab...@gmail.com
ab...@gmail.com a...@yahoomail.com a...@yahoomail.
Dear Gobet,
Use following formula in the column B and drag it down.
=RIGHT(A2,LEN(A2)-FIND("@",A2)+1)
solved workbook is also attached. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Dec 22,
Hi Andrea,
Please find attached the solution in the excel file. Let me know if this is
convinient for you.
Thanks,
Abhijeet Singh
Akamai Technologies, Bangalore
On Wed, Dec 23, 2009 at 8:32 AM, Harmeet Singh wrote:
> PFA file
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackB
PFA file
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Tue, Dec 22, 2009 at 11:25 PM, Andre Gobet wrote:
> Hello
>
> I've a list in Excel of about 1000 e-mail adresses from our internal
> Database. Now i want to extract from this list only the domain names
> to pu
Hello
I've a list in Excel of about 1000 e-mail adresses from our internal
Database. Now i want to extract from this list only the domain names
to put in to our Spam Filter for Whitelisting.
Example List in Excel
andre.go...@sesamnet.ch
g...@bluewin.ch
Now i'd like to have a list with only the D
