Excel Guides

Combining Numbers and Text in a Cell in Excel

You can combine numbers and text in a cell in Excel by using the & operator or the CONCAT function. The & operator concatenates two values together and returns a combined string. The CONCAT function is a built-in function that concatenates a list of strings together and returns a combined string. If you want to add space between the values being combined, you can use the SPACE function.

To use the & operator, enter the following formula in a cell:

=A1&" "&B1

This formula will concatenate the contents of cells A1 and B1, with a space between them. You can also use the CONCAT function like this:

=CONCAT(A1," ",B1)

Both of these formulas will return the same result. If you want to add more than two values together, you can use the & operator multiple times or nest multiple CONCAT functions. For example, this formula will concatenate three cells together:

=A1&" "&B1&" "&C1

This formula will do the same thing:

=CONCAT(A1," ",B1," ",C1)

You can also use the SPACE function to add space between values. The SPACE function takes one argument - the number of spaces you want to add. For example, this formula will add two spaces between the values in cells A1 and B1:

=A1&"  "&B1

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.