Forum Discussion
Kimberly Niles
Jul 08, 2017Copper Contributor
Find & Replace, NOT Finding!
Hello,
I am having trouble finding words in an excel worksheet. I tried multiple options with the Find & Select, but when I type in a name or words that I know are in the excel sheet, nothing shows up.
After scrolling through the excel document and locating the text I was searching for, I will match it exactly into Find & Select and it still does not recognize it?!
Please help, I'm on a deadline and have hundreds to go through!
4 Replies
Sort By
- Detlef_LewinSilver Contributor
Hi
Is the text a result of a formula? Then klick on "Options" and change "Look in:" from "Formulas" to "Values".
- Kimberly NilesCopper Contributor
yes I have tried that, still no luck
Hi Kimberly,
Could you please send us any sample
- create new workbook;
- put any text in 2-3 cells
- send it to us informing which text in it you try to find (if that doesn't work)
Thanks