Excel TIPS - Function CONCATENATE

CONCATENATE

 CONCATENATE joins two or more text strings into one text string.

=CONCATENATE(text1,text2,text3,. . . . .)

Examples:

	A	B
1	110001	1259535
2	ROHIT	KUMAR

                    FORMULA                                             RESULT

=CONCATENATE(A1,B1)                                 1100011259535

=CONCATENATE(A2,B2)                                 ROHITKUMAR

=CONCATENATE(A2,”  “,B2)                           ROHIT  KUMAR                      

** Put “ ‘’ between text strings for space **