In Excel, you can combine text with number, 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.

Contents

## Combine text with numbers

### An ampersand (&)

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

`=A2&" "&B2&" is "&C2&" years old."`

You can run this formula to 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.

`=CONCAT(A2," ",B2," is ",C2," years old.")`

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.

`=A2&" "&B2&" was born in "&YEAR(C2)&"."`

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