Ask Your Question

=concatenate function won't work

asked 2019-03-28 00:31:37 +0100

Peter B gravatar image

updated 2019-03-28 00:36:52 +0100

I have a simple spreadsheet where I want to use the =concatenate function to combine the text, "Dec", in cell A1 with a blank space and the text, "1837", in cell B1 to be put in cell C1. I have entered the following in cell C1: =CONCATENATE(A1; " "; B1). It will not return the result "Dec 1837" in C1. The cell just contains the above function. I have Data>Calculate>AutoCalculate checked and I'm using LibreOffice Version: (x64) on a fully updated Windows 7 machine. I assume I have something set incorrectly or not installed properly. What could I be doing wrong? I can supply a copy of the ODS spreadsheet if needed. Thank you for your time and effort... Peter Bradish

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-28 00:55:14 +0100

Lupp gravatar image

Most probably your cell is dedicated to contain text by setting the (fake) Numbers format code @. Such a cell will keep anything you enter (including formulas) as a literal text.

edit flag offensive delete link more


I don't understand what a "(fake) Numbers format code @" is. How do I determine this and what should I format the cell (C1) to?

Peter B gravatar imagePeter B ( 2019-03-28 01:04:22 +0100 )edit

Format Cells...>Numbers tab>List at the left under Category: Bottom item Text, if chosen, puts the @ into the format-code line. This doesn't realy format numbers, but tells the cell not to apply a recognition process to entered/edited characcter sequences, but to take and keep them literally.
Cells containing formulas for evaluation must recognize them as formulas first. Therefore these cells must be formatted to a true Numbers format, A new recognition may require in addition some marginal editing.

Lupp gravatar imageLupp ( 2019-03-28 01:31:20 +0100 )edit

Got it. It works now. Thank you very, very much. I had no idea. Had never run into that before... Peter

Peter B gravatar imagePeter B ( 2019-03-28 01:39:01 +0100 )edit

Please, if the answer solves the question click ✔.

m.a.riosv gravatar imagem.a.riosv ( 2019-03-28 15:49:03 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-28 00:31:37 +0100

Seen: 786 times

Last updated: Mar 28 '19