In the following example, you’ll see what happens if you try to join text and a number without using the TEXT function. In this case, we’re using the ampersand ( &) to concatenate a text string, a space (" "), and a value with =A2&" "&B2. As you can see, Excel removed the formatting from the date in cell B2.