• How do you Get Look In to include VALUES when using Find & Replace

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » How do you Get Look In to include VALUES when using Find & Replace

    • This topic has 1 reply, 2 voices, and was last updated 16 years ago.
    Author
    Topic
    #459608

    This is something that has anoyed me about Excel for a long time; how to get the ‘Look In’ drop down field on the Replace Tab of Excels Find & Replace dialog, to include VALUES as an option and not just FORMULAS which it always seems to default to. If you switch to the FIND tab then Look In will include VALUES as well as COMMENTS but thats no good if you are trying to Replace something.

    I know this is possible because I do somehow, after a lot of tinkering with the Find & Replace dialog, will get Look In to list VALUES in the drop down. I don;t know how I do it when this happens and every time I need to do this I have to spend X amount of time trying to get Excel to let me choose VALUES.

    Does anyone know what the deal is with Excels Find & Replace making it so difficult to Look In VALUES?

    BTW – I’m needing to select VALUES because what I’m trying to replace is the non-visible character that has the ASCII value of 160 which for some reason the software we use, likes to enbed into the cells of Worksheets it creates to list reporting info on the accounting application we use.

    Thanks

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: How do you Get Look In to include VALUES when using Find & Replace

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: