Hi,
I have severall spread sheets where I build a formula through concatenate, until I get the final formula on a cell that looks like this:
CONCATENATE(A1, A2)
After this, I always have to copy to notepad and back to Calc to get the formula result.
Is there a way that I can have a cell to update automaticly from a formula on another cell?
Example
A1 = "Hello "
A2 = “World”
A3 = “=CONC(A1, A2)”
I want A4 to display “Hello World”
Thanks in advance