concat

Concatenate text values.

Syntax

v = concat(text1, text2, ...)

Description

Returns the concatenation of all arguments. Unlike strcat, preserves trailing whitespace on each input. Excel’s modern replacement for CONCATENATE.

Example

concat('Hello', ' ', 'World')    % 'Hello World'

See also

• textjoin — Concatenate text values with a delimiter.
• strcat — Concatenate strings horizontally.
• append — Concatenate strings without trimming.