I’m doing some analysis of Help Desk data, and I often use Excel for this task.  Now I know a helpdesk caller did log a problem with the subject “five things I hate about my iPhone”.

But Excel couldn’t find it (see picture right).

The problem was caused by the Excel feature “Find by format” feature (red dot).  To turn it off, click on the Format button (green dot), and then select the Clear option.

Related posts:

Remove hidden data from Microsoft Office documents. How to use VLOOKUP on Microsoft Excel Date Mail Merge Bug fixed in Office 2007

Powered by YARPP.