Stripping out characters
 

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!

Stripping out characters
 

Copy the column to another column--just in case:

Select the column
Edit|Replace
what: *@
with: (leave blank)
replace all

(and once more)
edit|Replace
what: .*
with: (leave blank)
replace all



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!

--

Dave Peterson

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!

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!

Stripping out characters
 

Sweet! And I don't need to know my RIGHT from my LEFT!

"Dave Peterson" wrote:

Copy the column to another column--just in case:

Select the column
Edit|Replace
what: *@
with: (leave blank)
replace all

(and once more)
edit|Replace
what: .*
with: (leave blank)
replace all



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!

--

Dave Peterson
.

Stripping out characters
 

On Thu, 3 Dec 2009 06:26:01 -0800, 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!

To return everything after the "@", and up to the FIRST "." :

=LEFT(MID(A1,FIND("@",A1)+1,99),FIND(".",MID(A1,FI ND("@",A1)+1,99))-1)

--ron