I have a list of headers that include ↑ (U+2191) in them, I want to write a formula in Excel VBA to do something when a cell contains this as the first character. However I can't seem to include it in the formula it just shows ?
e.g.
.FormulaR1C1 = "=IF(LEFT(RC[-8],1)=""?"","""",RC[-19])"
what...