PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONCATENATE FUNCTION STICKS OR JOINS ANY TWO OR MORE GIVEN MIX OF TEXTS OR NUMBERS.
CONCATENATE FUNCTION joins the separate text strings, strings and number or number and number into one final string.
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
The Syntax for the function is
=CONCATENATE ( TEXT1 , TEXT 2, …) OR
=CONCATENATE(TEXT1, NUMBER1, ….)
TEXT1 ANY TEXT FRAGMENT
TEXT2 ANY TEXT FRAGMENT
NUMBER1 ANY NUMBER
Let us try to understand the CONCATENATE FUNCTION by trying various examples.
We have text in the cell D5 and text in th ecell E5.
We can simply do that by following the steps
Let us try to understand the CONCATENATE FUNCTION by trying various examples.
We have text in the cell D5 and text in the cell E5.
We can simply do that by following the steps
Let us try to understand the CONCATENATE FUNCTION by trying various examples.
We have text in the cell D9 and text in the cell E5.
We can simply do that by following the steps
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE