Excel Function

CONCATENATE

Legacy function to concatenate text values.

CONCATENATE(text1, [text2], ...)

Arguments

text1

Required

Value for text1.

text2

Optional

Value for text2.

Practice Preview

Use CONCATENATE to concatenate cell B2 (Name in column B) and cell C2 (Email in column C) by listing them one by one.

Example Table

#
AEmployee ID
BName
CEmail
DPayment Amount
EAmount Text
2E001Taro Tanakat.tanaka@example.com12001200
3E002Hanako Suzukih.suzuki@example.com980980
4E003Ken Satok.sato@example.com24502450
5E004Aya Takahashia.takahashi@example.com30003000
6
7
8

How to Use (Formula)

=CONCATENATE(B2, C2)

Result

Taro Tanakat.tanaka@example.com

Practice This Function

Start Function PracticeBack to Function List

CONCATENATE FAQ

How do I use CONCATENATE in Excel?

Use CONCATENATE when you want to combine multiple text values. Enter Text 1, Text 2 in that order, then add optional arguments when needed.

Where can I practice CONCATENATE?

Use the "Start Function Practice" button to jump straight into CONCATENATE drills.

What arguments does CONCATENATE use?

The main arguments are Text 1, Text 2. Start with the required ones, then add optional arguments if needed.