Excel Function

CONCATENATE

Legacy function to concatenate text values.

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

Arguments

text1

Required

Enter a text value (wrap with quotes when needed).

text2

Optional

Enter a text value (wrap with quotes when needed).

Practice Preview

Use CONCATENATE to return the result with these settings (Text 1: B2 (cell B2 (Name in column B)), Text 2: C2 (cell C2 (Email in column C))).

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.