Question EN

How do I combine text from multiple cells in Excel?

Answer

Use the & operator or the CONCATENATE function. For example, =A1&" "&B1 joins cell contents with a space between them.

Detailed explanation

Combining text (concatenation) is a common task when working with data.

The & Operator

The simplest approach:

=A1&B1

Joins the contents without a space. To add a space:

=A1&" "&B1

The CONCATENATE Function

=CONCATENATE(A1, " ", B1)

Does the same thing but can be clearer for complex formulas.

TEXTJOIN (Excel 2016+)

Handy for joining a range with a delimiter:

=TEXTJOIN(", ", TRUE, A1:A5)

Joins all cells with a comma, skipping empty ones.

Practical Examples

Full name: =B2&" "&C2&" "&D2
Address: =A1&", "&B1&", "&C1
Product code: =UPPER(A1)&"-"&B1

02.02.2026 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I calculate a percentage in Excel?

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I calculate an average in Excel?

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free