concatenate in openoffice calc

If you want a cell in OpenOffice Calc to contain multiple types of text (e.g. a fixed string and the result of a function), use the CONCATENATE function. For example, if the sum of column D is 19, then a cell containing =CONCATENATE(“YES=”, SUM(D2:D40)) will display YES=19.

~ by azimout on November 6, 2009.