how can i convert an email address to a web address

A

Arvind Sikar

I have a huge data base of email address. I want to add the web address also
in my data base. i would like to convert the email address to a web
address.e.g.if i have in my data base [email protected] in another cell i
want to have data which picks every thing after the @sign and add www. as
prefix. So the new data in a new cell should look like www.hotmail.com
 
J

joeu2004

Arvind said:
I have a huge data base of email address. I want to add the web address also
in my data base. i would like to convert the email address to a web
address.e.g.if i have in my data base [email protected] in another cell i
want to have data which picks every thing after the @sign and add www. as
prefix. So the new data in a new cell should look like www.hotmail.com
Click to expand...

First, are you aware that just because there is a mail server at
foobar.com, that does not mean that there is a web server at
www.foobar.com or even at foobar.com.

That said, does the following meet your needs?

MID(A1, 1+FIND("@",A1), LEN(A1)-FIND("@",A1))
 
A

Aqib Rizvi

Arvind

Assuming your emails are listed in Column A, from A1 downwards.
Write the following formula in cell B1.
Double click the handle to copy it along your data in column A.

=CONCATENATE("www.",RIGHT(A1,LEN(A1)-FIND("@",A1)))

Regards
Aqib Rizvi
 
J

joeu2004

I said:
MID(A1, 1+FIND("@",A1), LEN(A1)-FIND("@",A1))
Click to expand...

Sorry, I forgot to prefix that as follows:

"www." & MID(...)

But Aqib posted a better formula, which I would write as:

"www." & RIGHT(A1, LEN(A1)-FIND("@",A1))
 
Top