Results 1 to 8 of 8

Excel 2007 : Search specific text in a string

Threaded View

nlm Search specific text in a... 12-13-2011, 07:51 AM
JBeaucaire Re: Search specific text in a... 12-13-2011, 08:09 AM
dilipandey Re: Search specific text in a... 12-13-2011, 08:18 AM
Fotis1991 Re: Search specific text in a... 12-13-2011, 08:19 AM
colen219 Re: Search specific text in a... 12-14-2011, 01:01 AM
nlm Re: Search specific text in a... 12-14-2011, 02:01 AM
Haseeb Avarakkan Re: Search specific text in a... 12-14-2011, 02:47 AM
nlm Re: Search specific text in a... 12-14-2011, 05:38 AM
  1. #1
    Registered User
    Join Date
    05-13-2011
    Location
    Birmingham
    MS-Off Ver
    Excel 2007
    Posts
    78

    Search specific text in a string

    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.

    =if(find("wxy.",A1),"Found","Not Found")
    This code will filter the results:
    wxy@abc.com
    wexy@aol.com
    john@wxy.co.uk
    Last edited by nlm; 12-14-2011 at 05:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1