which parameters to use for search

[nymix]

Hi
i have worksheet with some 30000 email addresses and I need to get
only the onces that have the email [email protected] (for example
[email protected] or [email protected] etc)

Is there a function to get this done with find or some filtering?

Help is appreciated.

 

[David Biddulph]

One way would be to use Data/ Text to Columns to split by the @ symbol, then
again to split by the dot, then test for the entry in column A being the
same as that in column B.

 

[nymix]

One way would be to use Data/ Text to Columns to split by the @ symbol, then
again to split by the dot, then test for the entry in column A being the
same as that in column B.

Thanks - that is obviously the only way - thought there would be a
lazy way around.

 

[David Biddulph]

It's not the only way, I'm sure. One could do string extraction by LEFT,
MID, RIGHT, etc. with FIND or SEARCH to look for the separators, but Data/
Text to Columns seemed to be the easy way.