Find function not working? | MrExcel Message Board
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 identifed times …
Can you make the FIND function case insensitive? - MrExcel
Aug 24, 2010 · Hi, I've got a formula (below) that I believe the FIND function is causing it to return case sensitive results. Is there any way to modify the formula to make it case insensitive? …
Range.Find () Function Returning Value instead of Range
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 found the …
Find text string Across Multiple Cells in a Row - MrExcel
Jun 20, 2012 · I am trying to accomplish something similar but am at a loss. I need to find the row number of a cell with text. Normally a match function would work perfectly but the text is not always …
Allow find function on protected sheet...? - MrExcel
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 the sheet …
How to change Spreadsheet search (find) results cell border colour
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 with my eyes …
LEFT with a Delimiter? | MrExcel Message Board
Mar 6, 2008 · The find function returns the character position of the first thing it is trying to find which in this case is the comma. So basically, it is trying to find a "," in New York, New York. The comma is at …
Alternative to Find Function in VBA | MrExcel Message Board
Jan 28, 2008 · I appreciate I could do this in excel with the 'Find' function, but I hoping that I might be able to do it in vba. Or put simply what is the vba equivalent of excels Find function?
Find and Replace bug - Can not look in values - MrExcel
Mar 13, 2014 · The Find function allows me to look in Formulas, Values and Comments, but the Find and Replace function only allows me to look in Formulas. I could have sworn that I previously used …
Excel Vlookup Index Match - Excel Tips - MrExcel Publishing
Apr 2, 2002 · Actually, this piece of it seems so trivial that it seems useless. But, when you replace the question mark with a MATCH () function, you have the solution. MATCH Function Here is the syntax: …