HOW TO USE CONCATENATE FUNCTION | CONCATENATE FUNCTION TRICK
HOW TO USE CONCATENATE FUNCTION
Concatenate Function use for Join TextBelow 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 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
|
