How to apply formulas from text

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

@FernandoGama - I recommend to look always to the Help file for the syntax of a function or better to

Functions by Category - LibreOffice Help

  1. Use CONCATENATE in formula (not CONC!)

  2. Select A3.

  3. Press F2 (edit cell) → F9 (calculate value) → Enter (insert result to cell) → Enter (finish edit)

Also you can press Ctrl+C and immediately Ctrl+Shift+V (uncheck Paste All and Formulas)

OR

use Find&Replace

Great tip, the copy & replace thing! Thanks!