IFTEXT

[schardt679]

IFTEXT is like IFERROR for text. It returns Value_If_Text for text cells and the array itself otherwise.

Calls IFBLANK.
Other functions on minisheet: AFORMULATEXT.

Screen Tip/ Comment: =IFTEXT(Array☛ range to check for text, [Value_If_Text]☛ value to return for text cells; =0) ⁂[]=optional; =default; =omit

=LAMBDA(Array,[Value_If_Text],
      LET(Arr, Array,          Val, Value_If_Text,
             Return, IF(ISTEXT(Arr), Val,  IFBLANK(Arr, "")),
             Return
      )
  )

LAMBDA Examples.xlsx
	A	B	C	D	E	F	G	H	I
1		IFTEXT
2
3		Original Data			Value_If_Text		Result
4		1			Numbers only		1	Numbers only
5			2				Numbers only	2
6		#N/A					#N/A
7
8		123	ABC				123	Numbers only
9
10		B5 contain space
11		C4 contains a non-breaking space
12		C8 contains white text
13		Formula in cell G4☛ =IFTEXT(B4:C8, E4)
14
IFTEXT

Cell Formulas
Range	Formula
G4:H8	G4	=IFTEXT(B4:C8, E4)
B13	B13	=AFORMULATEXT(G4)
Dynamic array formulas.