LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how can i convert an email address to a web address

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract email address and place into a new column Inquirer Excel Worksheet Functions 6 July 6th 06 09:44 PM
add email address to a list of names biochemist Excel Discussion (Misc queries) 5 May 17th 05 05:17 PM
I want to pull out companies without an email address? Pudlicious Excel Worksheet Functions 0 March 15th 05 04:43 PM
how do I make make my hyperlinks show the email address they are . Dustin Excel Discussion (Misc queries) 0 January 13th 05 01:39 AM
Remove Email address header Mark Excel Discussion (Misc queries) 2 December 3rd 04 10:27 PM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"