Combine Text with Formula in Excel

In Excel, you can combine text with numbers, formulas, dates, etc., and display it inside a single cell. There are a few ways you can do it in Excel. In this tutorial, I’ll show you how.

Combine text with numbers

An ampersand (&)

To combine text with numbers inside a formula, you can use the ampersand (&) operator. This formula combines text, and cell references (text and numbers) and displays it as a string.

You can run this formula on multiple examples, to see how it works.

The CONCAT function

You can also use the CONCAT function (formerly CONCATENATE) instead of an ampersand to achieve the same result.

The CONCAT function looks a bit cleaner than the previous formula with an ampersand.

Combine text with dates

You can also use a formula where you combine text with a date.

The YEAR function takes a year from the date and displays the year of birth for these people.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.