=concatenate function won't work
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: 6.1.5.2 (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