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