Ask Your Question
0

How to apply formulas from text [closed]

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

Fernando Gama gravatar image

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

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
0

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)

OR

use Find&Replace

ChangeFormulasToResults

edit flag offensive delete link more

Comments

Great tip, the copy & replace thing! Thanks!

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

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

https://help.libreoffice.org/Calc/Functions_by_Category

edit flag offensive delete link more

Question Tools

Stats

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

Seen: 297 times

Last updated: Mar 20 '13