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

format and display text values. Use CONCATENATE to Legacy function to concatenate text values. use B2 for text1, use C2 for text2. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=CONCATENATE(B2, C2)

Practice This Function

Practice in Sequential Mode Back to Function List