29 January 2015

Excel cannot find the data you're searching for

Sometimes Excel cannot find text in a cell that is clearly visible. Some workarounds and solutions:

  • In the "Find and Replace" dialog, untick "Match entire cell contents".
  • In VBA, specify the LookAt parameter, .Find(..., lookat:=XlLookAt.xlPart)
  • In your worksheet, remove custom formatting from the cell range you are searching.

The last workaround is pretty weird. One would think that formatting shouldn't affect searching for data!