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 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

Arvind Sikar wrote:
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 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

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))

I wrote:
MID(A1, 1+FIND("@",A1), LEN(A1)-FIND("@",A1))

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))

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