Concatenate function

To use this function, choose Calc > Calculator.

Combines two or more text columns side-by-side and stores them in a new column.

Syntax

CONCATENATE(text,text,...)

For text, specify each column or value to combine. Minitab treats numeric or date/time columns (for example, a street address) as text characters.

Example

A human resources assistant wants to combine a column of first names with a column of last names. He enters the expression CONCATENATE(C1,C2) and stores the results in C3.

C1-T C2-T C3-T
First name Last name Name
Sarah Jenkins Sarah Jenkins
Rick Salazar Rick Salazar
Jasmine Evra Jasmine Evra