CONCATENATE function

This text function is very helpful if we need to join several words or text strings together.

	A	B	C
1	1	0	=CONCATENATE(A1,B1)
2	2	1	=CONCATENATE(A2,B2,"A")
3	3	2	=CONCATENATE(A3," ",B3,"A")

result

	C
1	10
2	21A
3	3 2A