NOTTEXT

[schardt679]

NOTTEXT returns TRUE or FALSE if a cell in a given range is not text.

Other functions on minisheet: AFORMULATEXT.

Screen Tip/ Comment: =NOTTEXT(Array☛ range to check if cells aren't text)

=LAMBDA(Array,
      --(ISTEXT(Array))=0
  )

LAMBDA Examples.xlsx
	A	B	C	D	E	F	G
1		NOTTEXT
2
3		Original Data			Result
4		1			TRUE	FALSE
5			2		FALSE	TRUE
6		#N/A			TRUE	FALSE
7		ABC			FALSE	TRUE
8		3	ABC		FALSE	FALSE
9
10		B5 & C6 contain space(s)
11		C1 contains a non-breaking space
12		C8 contains white text
13		Formula in cell E4☛ =NOTTEXT(B4:C8)
14
NOTTEXT

Cell Formulas
Range	Formula
C4	C4	=CHAR(160)
E4:F8	E4	=NOTTEXT(B4:C8)
B5	B5	=CHAR(32)
B6	B6	=NA()
C6	C6	=REPT(" ", 5)
B13	B13	=AFORMULATEXT(E4)
Dynamic array formulas.