Quote Originally Posted by mdmackillop
If the formula in A3 is =A1+A2, then Len([A3].Value) = 1, even if there is nothing in either A1 or A2, or am I missing something?
That is because the + coerces it to a number, so the cell will contain 0.