which parameters to use for search

  • Thread starter Thread starter nymix
  • Start date Start date
N

nymix

Hi
i have worksheet with some 30000 email addresses and I need to get
only the onces that have the email (e-mail address removed) (for example
(e-mail address removed) or (e-mail address removed) etc)

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

Help is appreciated.
 
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.
 
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.
Click to expand...

Thanks - that is obviously the only way - thought there would be a
lazy way around.
 
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.
 
Back
Top