Excel find and replace not working.

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.

Bookmark and Share

Comments are closed.