copy selected

  • Thread starter Thread starter hEE Hee
  • Start date Start date
H

hEE Hee

HI
I have about 3000 email address in column A from spammers :(
here is the sample
(e-mail address removed) 38011
(e-mail address removed) 38035

How can I copy only the domain names in column B and change any
characters in to * and also delete the followed by 5 letters number???
thanks
 
This formula does the first bit

=MID(A24,FIND("@",A24)+1,FIND(" ",A24)-FIND("@",A24))

don't understand what you mean by the second bit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks Bob.
this will do.

| This formula does the first bit
|
| =MID(A24,FIND("@",A24)+1,FIND(" ",A24)-FIND("@",A24))
|
| don't understand what you mean by the second bit.
|
| --
|
| HTH
|
| Bob Phillips
| ... looking out across Poole Harbour to the Purbecks
| (remove nothere from the email address if mailing direct)
|
| | > HI
| > I have about 3000 email address in column A from spammers :(
| > here is the sample
| > (e-mail address removed) 38011
| > (e-mail address removed) 38035
| >
| > How can I copy only the domain names in column B and change any
| > characters in to * and also delete the followed by 5 letters
number???
| > thanks
| >
| >
|
|
 
Back
Top