Thread: how can i convert an email address to a web address
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default how can i convert an email address to a web address
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))

Reply With QuoteReply With Quote