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.

1 |
=A2&" "&B2&" is "&C2&" years old." |

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.

1 |
=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.

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

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