Concatenating multiple text columns into one column

Use Data > Concatenate to combine two or more text columns and store the result in a new column.

Example

You have a column of last names (C1) and a column of first names (C2) and you want to combine them into one column (C3).

C1-T C2-T C3-T
Last First First and Last
Allen Jo Jo Allen
Lee Max Max Lee
Gonzales Maria Maria Gonzales
Jones Graham Graham Jones
Spitz Roberto Roberto Spitz
Note

In this example, you need to manually add the spaces between the first and last name.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy