Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
which parameters to use for search
Hi
i have worksheet with some 30000 email addresses and I need to get only the onces that have the email (for example or etc) Is there a function to get this done with find or some filtering? Help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
which parameters to use for search
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. -- David Biddulph wrote in message ... Hi i have worksheet with some 30000 email addresses and I need to get only the onces that have the email (for example or etc) Is there a function to get this done with find or some filtering? Help is appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
which parameters to use for search
On 22 marras, 13:50, "David Biddulph" <groups [at] biddulph.org.uk
wrote: 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. -- David Biddulph wrote in message ... Hi i have worksheet with some 30000 email addresses and I need to get only the onces that have the email (for example or etc) Is there a function to get this done with find or some filtering? Help is appreciated. Thanks - that is obviously the only way - thought there would be a lazy way around. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
which parameters to use for search
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. -- David Biddulph wrote in message ... On 22 marras, 13:50, "David Biddulph" <groups [at] biddulph.org.uk wrote: 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. -- David Biddulph wrote in message ... Hi i have worksheet with some 30000 email addresses and I need to get only the onces that have the email (for example or etc) Is there a function to get this done with find or some filtering? Help is appreciated. Thanks - that is obviously the only way - thought there would be a lazy way around. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL & Like Parameters | Excel Discussion (Misc queries) | |||
formulas using if parameters | Excel Worksheet Functions | |||
Too few parameters | Excel Discussion (Misc queries) | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
too few parameters | Excel Discussion (Misc queries) |