The Excel concatenate function can be used to combine multiple cells into one.

Syntax

CONCATENATE (text1,text2,…)

Text1, text2, are items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references. Real world example:

Cell A1 contains: I
Cell A2 contains: Love
Cell A3 contains: Concatenate

Type =concatenate(a1,a2,a3) in A4

The result in A4 would be: ILoveConcatenate

Note:
The “&” operator can be used instead of Concatenate to join text items.

Joseph Harris
ExcelYogi.com
Analyst Resources

Related posts:

1. Excel CELL () Function The CELL function can be used to find out information...