View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Stripping out characters

=MID(A1,SEARCH("@",A1)+1,SEARCH(".",A1,SEARCH("@", A1))-SEARCH("@",A1)-1)

--
Regards!
Stefi



€˛Stephanie€¯ ezt Ć*rta:

Hi-
I have a field that contains email addresses. I would like to strip the
address down to just the domain:

= gmail
= comcast
= aol

So essentially I want to capture anything after the "@", up to the "."

I'd appreciate your suggestions!