Thread: parse email address
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
  
Posts: 390
Default parse email address
In , Michael Connolly
spake thusly:

Given a cell containing:


I need to extract:
reallycoolurl.com

Assuming address in A1:

=MID(A1,FIND("@",A1)+1,100)

(Presumes no domain parts are longer than 100 chars.)

-dman-
Reply With QuoteReply With Quote