copy selected

H

hEE Hee

HI
I have about 3000 email address in column A from spammers :(
here is the sample
[email protected] 38011
[email protected] 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
 
B

Bob Phillips

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)
 
H

hEE Hee

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
| > [email protected] 38011
| > [email protected] 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
| >
| >
|
|
 
Top