Thread: how can i convert an email address to a web address
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aqib Rizvi Aqib Rizvi is offline
external usenet poster
  
Posts: 9
Default how can i convert an email address to a web address

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

Reply With QuoteReply With Quote