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.
Helpful links for the prerequisites mentioned above

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

FUNCTION CONCATENATE EXAMPLE
EXCEL:CONCATENATE FUNCTION EXAMLPE

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

SUPPOSE
TEXT1 = HIS BROTHER IS
VALUE= AGE
TEXT 2=YEARS OLD
 
EXCEL:CONCATENATE FUNCTION EXAMLPE 2

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

 

 

FUNCTION CONCATENATE EXAMPLE OUTPUT
EXCEL:CONCATENATE FUNCTION EXAMLPE 2 CORRECTED OUTPUT
THE OUTPUT IS AS DESIRED, WITH THE PROPER SPACES.
 

 

KNOWLEDGE BYTES

FLEXIBILITY WITH CONCATENATE FUNCTION

CONCATENATE FUNCTION is very flexible and simple in usage.
We can use it with CELL ADDRESS containing values or text, explicit text in the function itself like “this is a text” or any other way we can think.
 
If we don’t want to use this function , we have an operator known as CONCATENATE OPERATOR which we can similarly use
the operator is &
 
concatenate(text1, text2) will give same output as text1 & text2.

 

OTHER WAYS TO REACH THIS ARTICLE

  • JOIN STRINGS, JOIN TEXT, HOW TO JOIN TEXT AND VALUE, & OPERATOR

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: