Excel

How to Concatenate in Excel

How to Concatenate in Excel

There are a few ways to concatenate in Excel. The easiest way is to use the & operator. For example, if you want to concatenate the values in cells A1 and A2, you would type =A1&A2 into a cell.

If you want to concatenate text and numbers, you can use the ampersand operator to combine them. For example, if you want to concatenate the text "Hello" and the number 5, you would type ="Hello"&5 into a cell.

If you want to concatenate text and text, you can use the ampersand operator to combine them. For example, if you want to concatenate the text "Hello" and the text "World", you would type ="Hello"&"World" into a cell.

If you want to concatenate text and a date, you can use the ampersand operator to combine them. For example, if you want to concatenate the text "Hello" and the date "1/1/2015", you would type ="Hello"&"1/1/2015" into a 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.