✅=C6:C18>”” (The same as ISTEXT)
TRUE : The Cell contains a Text
FALSE : The Cell Contains a number or Empty
✅=C6:C18<“” (The same as ISNUMBER)
➡TRUE : The Cell contains a Number
➡FALSE : The Cell Contains a Text or Empty
………………
✅=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),….
✅=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),….