Posted to microsoft.public.excel.worksheet.functions
|
|
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!
|