Filter does not show a value which is there in a column

**gnagygergo** · 03-30-2012, 07:38 AM

Fact:
In the column A I have a lot of Printer model names. Among the values there is the “Lexmark X950” as well.

Problem:
If I turn on the Filter, I cannot see this value in the filter window’s list. So if I did’nt know that I have this value in the list the Filter could fool me. This is very strange.
Furthermore, if I search for this value (ctrl+f) it does not find the cell with this value either!!! If I search for a part of this value eg “X950” it will find the cell.

In fact, if I delete the content of the cell and type this value manually, the problem does not persist any more. But I can't do this check for all values. The content of this sheet is filled by a macro anyway.

Did anyone of you meet sth like this? Can you, please, give me some tips what is the cause?

**NBVC** · 03-30-2012, 08:21 AM

Is that space between Lexmark and X950 a true space or is it another hidden character.....

Enter this formula in an empty cell, subbing A1 for the cell reference that string is in....

=CODE(MID(A1,8,1))

what do you get?

**gnagygergo** · 03-30-2012, 10:25 AM

I got 160.

**NBVC** · 03-30-2012, 10:50 AM

A quick way to clean it up is use a formula in a free column

=SUBSTITUTE(A2,CHAR(160)," ")

copied down where A2 is top cell in the column of interest.

Then copy that column and paste special >> values over the original and delete the formula column.

You should be better off now...