Answer for Q3
Open VBA and create a macro:
Option Explicit
Function ZIsApostrophe(rng As Range) As Boolean
ZIsApostrophe = rng.PrefixCharacter = "'"
End Function
Use the custom function ZIsApostrophe()
to check if a cell starts with ' .
For example type ZIsApostrophe(A3)
to check if the cell A3 starts with ' . It will return the value TRUE or FALSE as the result.
Credit: José Augusto
Answers for 1, 2, and 4
1a ) =IF(FORMULATEXT(A1)="=TODAY()",1,0)
1b ) =IF(LEFT(FORMULATEXT(A1),5)="=TIME",1,0)
1c ) [ edit the 1b solution ]
2 ) =IF(AND(CODE(MID(FORMULATEXT(A1),2,1))>=65,CODE(MID(FORMULATEXT(A1),2,1))<=90),1,0)
[ you may refer the details of code() in the help file.. (: ]
4 ) =IF(AND(code(right(FORMULATEXT(A1),1))>=48,CODE(right(FORMULATEXT(A1),1))<=57),1,0)
Credit: p.phidot
FORMULATEXT
will give you the text of a formula, you can then look for any string in it