Concatenation in Microsoft Excel

There are two ways to concatenate (merge the contents of two cells) in Microsoft Excel.

	A	B	C	D	E
1		Item 1	Item 2	Function	Result
2	Method 1	Hello	World!	=CONCATENATE(B2,C2)	Hello World
3	Method 2	This is a way to	Concatenate	=B3 & C3	This is a way to Concatenate

The first method uses the =CONCATENATE([item 1], [item 2], [item ...]) function. Each cell specified within this function will be joined.

Alternatively, you can simply use the & symbol to join the contents of two cells.