How to join text with numbers

Let’s take a look.

TheTEXT functionhas just one purposeto convert a number into a text value using a specific number format.

In the first table, we have some random numbers in the left column.

I’ll add a formula in column C to show just the raw values in the General number format.

In column E, there is already another formula that points back to column B. you’ve got the option to see this clearly if I temporarily switch to the General number format.

Now let’s join some text with numbers.

In column E, I’ll enter a formula that concatenates the two values together without any formatting.

you could see that the result is not really usable.

The numbers without formatting just don’t look right.

To fix this problem, I can use the TEXT function.

This gives us a much better result.