ExcelBanter - View Single Post

Bob Phillips

Mine handles that but still bales out on
<g

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Shorter, but what does it do if his address is ?
--
David Biddulph

"Teethless mama" wrote in
message ...
Slightly shorter

=MID(A1,FIND("@",A1)+1,FIND(".",A1)-FIND("@",A1)-1)

"Bob Phillips" wrote:

=MID(A1,FIND("@",A1)+1,FIND(".",A1,FIND("@",A1)+1)-FIND("@",A1)-1)

and copy down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Laura Vanhoorelbeke" wrote in message
...
Hi,

I have been working on a worksheet in Excel and I have placed all my
Email Addresses in my Column A. Now I want to have all the domain
names in
my column B.
For example:
Cel A1:
Cel B1: hotmail

Now my question is, how can I do this with only 1 formula?

Thank you for helping me.