HOW TO USE CONCATENATE FUNCTION | CONCATENATE FUNCTION TRICK

HOW TO USE CONCATENATE FUNCTION

Concatenate Function use for Join Text

Below Example 1-
=CONCATENATE(A4," ",B4)

Example 2- How to CONCATENATE Function with Line Breaks
=CONCATENATE(A15,CHAR(10),B15,CHAR(10),C15,CHAR(10),D15)
Note-After use function select use fuction cell and click home tab and click Wrap Text button Example 3- How to CONCATENATE Function Join Text using & sign =CONCATENATE(A23&" "&B23) Example 4- How to CONCATENATE Function With Text formulas =CONCATENATE("Total  - ",TEXT(SUM(B28:B30),"£#,###.00"))

Example 5- How to CONCATENATE Function Using with Date time
Date and Time	Formulas	Result
16-Apr-20	=CONCATENATE( "The Date is: ", TEXT( A37, "dd/mm/yyyy" ) )	The Date is: 16/04/2020
12:00:00 AM	=CONCATENATE( "The Time is: ", TEXT( A38, "hh:mm am/pm" ) )	The Time is: 12:00 AM