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














About Me

author Click here for Connect FB

Click here for Linkedin