#OPENOFFICE CONCATENATE CODE#

This does not include the source code of LibreOffice, which is licensed under the GNU Lesser General Public License ( LGPLv3).

Please note that all contributions to The Document Foundation Wiki are considered to be released under the Creative Commons Attribution-ShareAlike 3.0 Unported License, unless otherwise specified.

This page was last edited 11:34:24, by Steve Fanning.

The exact string returned would be dependent on the contents of the cells in column A, column B, row 3, and row 4. In this example, the contents of cells A3, A4, B3, and B4 could appear twice in the returned string. Here the function concatenates the contents of all cells in columns A and B, together with the contents of all cells in rows 3 and 4.

Note the order of concatenation for a cell range. Here the function concatenates the contents of all cells in the range A1:B3, returning 'A1B1A2B2A3B3'. Here a string and a number are passed as arguments, with the function concatenating them and returning 'Total: $123.45'. The journey of a thousand miles begins with one step.

Here ten individual strings are passed in an inline array, with the function concatenating them and returning 'The journey of a thousand miles begins with one step.'. String 1 is a text string (in quotation marks), a number, a reference to a cell, a reference to a cell range, or an inline array of strings (within curly braces ') Returns a text string formed by concatenating the string arguments end-to-end. The CONCAT function is an enhanced version of the CONCATENATE function, with CONCAT accepting cell ranges as arguments.Р”В¬ONCAT( String 1 ]]) Concatenates multiple text strings into a single string.

Openoffice concatenate