Ask Your Question

How to apply formulas from text [closed]

asked 2013-03-20 12:01:32 +0200

Fernando Gama gravatar image


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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-27 03:49:29.004115

2 Answers

Sort by » oldest newest most voted

answered 2013-03-20 12:16:09 +0200

JohnSUN gravatar image

updated 2013-03-20 17:07:53 +0200

  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)


use Find&Replace


edit flag offensive delete link more


Great tip, the copy & replace thing! Thanks!

davidgaca gravatar imagedavidgaca ( 2015-11-01 11:34:40 +0200 )edit

answered 2013-03-20 13:49:05 +0200

ROSt52 gravatar image

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

edit flag offensive delete link more

Question Tools


Asked: 2013-03-20 12:01:32 +0200

Seen: 297 times

Last updated: Mar 20 '13