How would I do this? I need to display the value of Cell A1 in Cell B1 as long as the value of Cell A1 isn't longer than 20 characters. And if the value of A1 is longer then 20 characters, 'SEE CELL C1' should be displayed in Cell B1 instead. And then Cell C1 would need to display the value of A1.
Now, I know I could go about it this way:
This formula in Cell B1:
=IF(LEN(A1)<=20,A1,"SEE CELL C1")
This formula in Cell C1:
=IF(B1="SEE CELL C1",A1,"")
I tried to do this here actually, but somehow I must not have been quite clear enough - Cell C1 must not and may not and can not have a formula in it, due to the fact that if Cell C1 doesn't get the value of Cell A1, then it needs to be available for manual data entry, and as far as I know, entering manual data into a cell that contains a formula replaces the formula, which will not do.
So what's my best option here?