I would like to share excel tricks with you
1.
=C6:C18>"" (The same as ISTEXT)
TRUE : The Cell contains a Text
FALSE : The Cell Contains a number or Empty 2.
=C6:C18<"" (The same as ISNUMBER)
TRUE : The Cell contains a Number
FALSE : The Cell Contains a Text or Empty
3.
=C6:C18>"0"
TRUE : The Cell contains a Text and it is NOT STARTING withSpecial characters like : ( @ # !$ % ^ & * } { [ ]...... , or space , char(10),UNICHAR(8203),…
FALSE : The Cell contains a number or Empty or starts with characters or space , char(10),UNICHAR(8203),…
4.
=C6:C18<"0"
TRUE : The Cell contains a Number OR Empty OR it is STARTING with characters or space , char(10),UNICHAR(8203),…
FALSE : The Cell contains a Text NOT starts with characters or space , char(10),UNICHAR(8203),….