
PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
EXCEL FUNCTIONS-CONCATENATE
INTRODUCTION
CONCATENATE function comes under the TEXT category in Excel.
CONCATENATE function simply joins the two text fragments into one.
It is one of the function which will be used over and again to make any dynamic text line where we can pic some numerical values and mixing some text fragments etc. which are very useful in practical reports.
PURPOSE OF CONCATENATE FUNCTION IN EXCEL
CONCATENATE FUNCTION joins the separate text strings into one.
PREREQUISITES TO LEARN CONCATENATE FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
SYNTAX: CONCATENATE
The Syntax for the function is
=CONCATENATE( TEXT1 , TEXT 2, …)
TEXT1 ANY TEXT FRAGMENT
TEXT2 ANY TEXT FRAGMENT
EXAMPLE 1:CONCATENATE IN EXCEL
DATA SAMPLE
LET US SEE WHAT DIFFERENT USES WE CAN MAKE OF CONCATENATE FUNCTION.
CASE 1:
text+text
STEPS TO USE CONCATENATE
In the above example two text fragments are put in F10 AND G10.
The function to combine them has been written in H10 as
=concatenate(F10,G10)
THIS FUNCTION WILL COMBINE THE TEXT AND OUTPUT IS SHOWN AS
HELLOEVERYONE IN H10
EXAMPLE 2:CONCATENATE IN EXCEL
TEXT+VALUE
EXPLANATION
The function is used as
=CONCATENATE(F10,G10,H10)
and the result is as shown as
HIS BROTHER IS15YEARS OLD
Now we can notice that SPACES are not proper near IS and YEARS.
Let us correct this error and do a little modification in the function as
=CONCATENATE(F10,” “,G10,” “,H10)
We have inserted spaces in between the joining fragments.
Let us check the output now
KNOWLEDGE BYTES
FLEXIBILITY WITH CONCATENATE FUNCTION
OTHER WAYS TO REACH THIS ARTICLE
JOIN STRINGS, JOIN TEXT, HOW TO JOIN TEXT AND VALUE, & OPERATOR
YOU MAY LIKE
- EXCEL-FUNCTION-CHAR
- EXCEL FUNCTIONS-HLOOKUP
- INTRODUCTION TO EXCEL FORMULAS:ARITHMETIC OPERATORS
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.