Cells appears blank but aren't ???

[rhombus4]

Have some cells which both appear to be blank

When I do the following formulas I get different results
=ISBLANK(B12) True, =ISTEXT(B12), FALSE, =ISNUMBER(B12), FALSE
=ISBLANK(B13) FALSE, =ISTEXT(B13), True, =ISNUMBER(B13), FALSE

Also When I did a Replace and Find, (didn't enter anything in the Find field) it found both cells

I only found it when I did a pivot table and I got an empty space in the Row Labels field
PS the 11 below is actually in the Count Box and not in Row Labels as it apears

Row Labels​	Count​
11​
Yes	250​
No	83​
Maybe	3​
(blank)	20​
Grand Total	367​

 

[sandy666]

try =CODE(B13)
you should see #VALUE!
if not there is any non-printable character probably

 

[Joe4]

ISBLANK FALSE seems to imply that it is NOT blank, right?

I like to use LEN, which checks the length of the entry in a cell.
Anything with a length greater than zero is not empty.

Then, you can use the ASCII table to find out exactly what it is, i.e. if the entry in cell A1 is length 1, then use this formula to return its ASCII code:
=CODE(A1)
and look it up on an ASCII table (Google ASCII table)

 

[rhombus4]

tried LEN and everything is 0, all =Code returns value
Also when I highlight the cells the first 4 where isblankis False the COUNT at the bottom goes up by1 whereas when it highlights the other 4 it stays at 4

Another Thing Initially they were sorted in Date Order, When I first sorted them by Name A-Z this is the order, and when I sorted by Z-A by name it stays as same order

Date​	Name​	ISBLANK​	ISNUMBER​	ISTEXT​	CODE​	LEN​
01/03/2019​		FALSE​	FALSE​	TRUE​	#VALUE!​	0​
07/03/2019​		FALSE​	FALSE​	TRUE​	#VALUE!​	0​
13/03/2019​		FALSE​	FALSE​	TRUE​	#VALUE!​	0​
19/03/2019​		FALSE​	FALSE​	TRUE​	#VALUE!​	0​
04/03/2019​		TRUE​	FALSE​	FALSE​	#VALUE!​	0​
10/03/2019​		TRUE​	FALSE​	FALSE​	#VALUE!​	0​
16/03/2019​		TRUE​	FALSE​	FALSE​	#VALUE!​	0​
22/03/2019​		TRUE​	FALSE​	FALSE​	#VALUE!​	0​

​

 

[rhombus4]

this is the pivot table for above

Row Labels​	Count of Date​
	4​
(blank)	4​
Grand Total	8​

​	​
	​

 

[Fluff]

If you run this, do all the ISBLANK formulae return false?

Sub rhombus()
   With Range("B2:B" & Range("A" & Rows.Count).End(xlUp).Row)
      .Value = .Value
   End With
End Sub

 

[sandy666]

maybe there is an empty string, =""
code = #value
len = 0
isblank = false
---
ribbon - home - (editing) Clear - clear all

 

[rhombus4]

No, All ISBLANK are True, All ISNUMBER and ISTEXT are False

 

[rhombus4]

maybe there is an empty string, =""
code = #value
len = 0
isblank = false
---
ribbon - home - (editing) Clear - clear all

definitely something there as when I deleted all the values or cleared all the values all isblank was True

 

[Fluff]

Oops, got it the wrong way round, ISBLANK should return TRUE for all.
It sounds as though you copy/pasted a range as values & some of the cells had a formula that returned ""