Posted to microsoft.public.excel.worksheet.functions
|
|
Stripping out characters
Hi,
try
=RIGHT(A51,FIND("@",A51)-2)
"Stephanie" wrote:
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!
|