How to combine two or more cell in Excel | Use of CONCATENATE Function / Formula in Excel

CONCATENATE

Use of CONCATENATE Function / Formula in Excel

Joins Several strings into one text string.

Syntax/Formula of CONCATENATE in Excel

The syntax of CONCATENATE function in Microsoft Excel is below

=CONCATENATE(text1,[text2],[Text3], …)

Example of CONCATENATE in Excel

Step 1: First type ADVANCED in cell A2, MS in cell B2, EXCEL in cell C2 and .BLOGSPOT.COM in cell D2.

Step 2: Type formula =CONCATENATE(A2,B2,C2,D2) in cell A4 and press enter.

CONCATENATE FUNCTION