Excel 2007 : Search specific text in a string

**nlm** · 12-13-2011, 07:51 AM

Hi,
I have 25K customer records consisting email address,Fname,Lname etc. I want to filter those email addresses having say wxy.com in their email address. I applied the following formula but did not work correctly.

Please Login or Register  to view this content.

This code will filter the results:
wxy@abc.com
wexy@aol.com
john@wxy.co.uk

**JBeaucaire** · 12-13-2011, 08:09 AM

Try: =IF(ISNUMBER(SEARCH("wxy.", A1)), "Found", "Not Found")

**dilipandey** · 12-13-2011, 08:18 AM

Hi Nim,

If you want to do this with Find function as shown in example:-

Please Login or Register  to view this content.

Regards,
DILIPandey

< click on below 'star' if this helps >

**Fotis1991** · 12-13-2011, 08:19 AM

Hi nlm

Try this:

=if(find("wxy.",A1),"Found","Not Found")

Hope to helps you.

**colen219** · 12-14-2011, 01:01 AM

Thanks ! JBeaucaire

**nlm** · 12-14-2011, 02:01 AM

Thanks JBeaucaire!

It worked. If we want to filter rows on two inputs like "wxy" and "abc" then will this formula works with OR operator?

I appreciate your help.

**Haseeb Avarakkan** · 12-14-2011, 02:47 AM

If you just have couple texts use them inside an Array like,

=IF(COUNT(SEARCH({"wxy.","abc"},A1)),"Found","Not Found")

Or enter all texts in a range, say in F1:F2, then use,

=IF(ISNUMBER(LOOKUP(9E300,SEARCH(F1:F2,A1))),"Found","Not Found")