How to make a complete non-blank criteria?

[prabha_friend]

Hi,
I need to build a complete non-blank criteria in an advanced filter. I know <> will give me all non-blanks (skipping pure blank cells). But as you see in the auto-filter criteria "Blanks" will also give the impure blanks (i.e cells containing only a space/spaces as thier value). How to build a criteria to not show both pure blanks and impure blanks?
Example,
Name
<>
<>
The above criteria is not working...
I want something like this:
Name
<>
=IF(LEN(B2)=1,B2<>" ")

 

[vds1]

Hi Prabha,

Have you tried Trim ?

something like

=IF(TRIM(B2)="","Blank","Not Blank")

 

[prabha_friend]

Hi vds,
I tried giving the criteria =IF(Trim(B2)="","<> "). Not skipping the impure blank cells
Regards,
Prabhakaran

 

[vds1]

Hi Prabha,

This must be char(160) space.. Try the below formula

=IF(TRIM(SUBSTITUTE(B2,CHAR(160),""))="","Blank","Not Blank")

Can you copy paste the content of cell B2 including that space ?