Nov 13, 2022 · Hello, I have encountered an issue when trying out the Range.Find() function in one of my workbooks: the function returns the very value I gave it instead of the cell where it …

Apr 8, 2002 · In the cases shown above the =FIND portion of the function will return a 3 in each case. I need it to return a 3 is case 1 and a 5 in cases 2 and 3 so that the =RIGHT function …

Aug 24, 2010 · I find that I have to use the ISNUMBER and SEARCH Functions because The criteria in the example cell of G5 will not always match the data entered into the range (TASKS …

Apr 17, 2019 · How to change Spreadsheet search (find) results cell border colour ? Seems so easy, but just cannot find anywhere that shows you. Excel 365 currently shows dark green, but …

Mar 16, 2024 · Where did you find something that suggests “IgnoreSpace” is a valid VBA argument for the Find function in Excel VBA? The documentation I found does not seem to …

Jan 5, 2011 · I have a similar requirement but when I used this code, to find the word "ERROR", it is also searching in the formula and taking action. I needed excel to check only in the outcome …

Aug 17, 2009 · Hi guys I have a worksheet full of data where, when the sheet is protected, the 'Find' function (Ctrl F) will not work. When it is unprotected it it fine. Any idea how I can keep …

Dec 2, 2010 · The search function is returning the NUMBER of the character. i.e. =search ("p",supply) will return 3 because the 1st "p" in supply is the 3rd character. So in your formula …

Oct 4, 2007 · I have a sheet with a list of names on and I've noticed that when I use ctrl+F to use the find function, even when I know i have entered the correct name it still will not work. I have …

Mar 16, 2021 · What version of Excel are you using? I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what …