+ Reply to Thread
Results 1 to 4 of 4

Find feature not working

Hybrid View

mrstinicum Find feature not working 04-19-2012, 11:04 AM
dilipandey Re: Find feature not working 04-22-2012, 03:08 PM
Cutter Re: Find feature not working 04-22-2012, 03:17 PM
FDibbins Re: Find feature not working 04-22-2012, 03:40 PM
  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    bear, delaware
    MS-Off Ver
    Excel 2007 Home and Student
    Posts
    1

    Find feature not working

    I am using Excel Home and Student 2007 on a Windows 7 platform. I have a lengthy file which I must correspond to another (photo) file, and I need to determine that all names in the picture file are also on the excel file. I keep doing a "find" to locate the info I am looking for, but the system comes back telling me (98 times out of a hundred) that the information is not contained in the file. This happens, even if I do a test "find" with the actual data I am looking for already showing on the screen. Example, I am looking for a part number - 226688G -. I am in the Excel file, and can see that part number on the page. Yet If I go to the "find" feature, the program still tells me that the data cannot be found anywhere in the file. I have something like 3500 files for check and really need the "find" feature to work.

    I thought maybe I needed to update my service pack, but when I tried, I was told that it was incompatible with my system. I checked my version number and it is 12.0.6612.1000.

    Any help would be greatly appreciated.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Find feature not working

    Hi mrstinicum,

    Welcome to the forum.

    When you do Ctrl + F (Find), you have three options in which data can be looked -> Values, Formulas, Comment..
    Click on Options, to get to see these options and try again. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Find feature not working

    Also - check for any spaces or invisible characters in your data (if you are trying to find exact matches).

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Find feature not working

    ok wait, are you trying to use the "find" feature in excel to find the name of another file strored somewhere?

    or do you have some text in 1 excel file that you are you trying to find in another excel file?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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