Thread: parse email address
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
  
Posts: 320
Default parse email address
Please don't cross-post.
=mid(a1,find("@",a1)+1,255)

"Michael Connolly" wrote:

Hi,
I need to parse a email address to get the url.

Given a cell containing:


I need to extract:
reallycoolurl.com

Any help is GREATLY appreciated.
Thanks
MJC



Reply With QuoteReply With Quote