To merge cells in OpenOffice Calc, copy the first cell you try the formula in eg. =CONCATENATE(A1; “-”; B1 ) Select all cells in that column and paste. Then that formula gets applied to all cells in the column. Copy Column and use Paste Special at your destination cell. Uncheck Paste All and Formulas. Copying [...]