Excel Guides

Combining Columns in Excel

There are a few different ways to combine columns in Excel. One way is to use the CONCATENATE function. This function takes two or more strings and combines them into one string. For example, if you have a list of first names in one column and a list of last names in another column, you can use the CONCATENATE function to create a third column that contains the full name of each person in the list. Another way to combine columns is to use the & operator. This operator concatenates two strings and returns a new string that is the combination of the two strings. For example, if you have a list of first names in one column and a list of last names in another column, you can use the & operator to create a third column that contains the full name of each person in the list.

You can also use the TEXTJOIN function to combine columns. This function is new in Excel 2016 and it makes it easy to combine cells that contain text. The TEXTJOIN function takes two or more strings and combines them into one string. For example, if you have a list of first names in one column and a list of last names in another column, you can use the TEXTJOIN function to create a third column that contains the full name of each person in the list.

If you want to combine columns and keep the data in separate cells, you can use the & operator or the CONCATENATE function. For example, if you have a list of first names in one column and a list of last names in another column, you can use either the & operator or the CONCATENATE function to create a third column that contains the full name of each person in the list, but with each name in its own cell.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.