PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

GOOGLE SHEETS FUNCTION-CONCATENATE

INTRODUCTION

CONCATENATE FUNCTION is one of the frequently used functions in GOOGLE SHEETS.
While creating the reports, we come into this situation frequently when we need to STICK two texts, number with text or two numbers together.
The requirement can be for the report or creating any unique column while using the vlookup or xlookup or any other type of lookup formula.
CONCATENATE FUNCTION STICKS OR JOINS ANY TWO OR MORE GIVEN MIX OF TEXTS OR NUMBERS.

PURPOSE OF CONCATENATE FUNCTION IN GOOGLE SHEETS

CONCATENATE FUNCTION joins the separate text strings, strings and number or number and number into one final string.

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 GOOGLE SHEETS.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, GOOGLE SHEETS LOGIN and internet connection.

SYNTAX: CONCATENATE FUNCTION

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

 

 

EXAMPLES:CONCATENATE FUNCTION IN GOOGLE SHEETS

EXAMPLE 1: COMBINING TEXTS AND NUMBERS IN GOOGLE SHEETS

Let us try to understand the CONCATENATE FUNCTION by trying various examples.

EXAMPLE 1:COMBING TEXTS AND NUMBERS

We have text in the cell D5 and text in th ecell E5.

We can simply do that by following the steps

  • Select the cell G5 and put the formula as
  • =CONCATENATE(D5,E5) and click ENTER.
  • The result will appear in the cell
  • The process is shown in the picture below.
google sheets concatenate
USING CONCATENATE FUNCTION IN GOOGLE SHEETS

EXAMPLE 2: COMBINING TEXTS IN GOOGLE SHEETS

Let us try to understand the CONCATENATE FUNCTION by trying various examples.

EXAMPLE 2:COMBIniNG TEXTS

We have text in the cell D5 and text in the cell  E5.

We can simply do that by following the steps

  • Select the cell G7 and put the formula as
  • =CONCATENATE(D7,E7) and click ENTER.
  • The result will appear in the cell
  • The process is shown in the picture below.
google sheets concatenate
USING CONCATENATE FUNCTION IN GOOGLE SHEETS

EXAMPLE 3: COMBINING NUMBERS IN GOOGLE SHEETS

Let us try to understand the CONCATENATE FUNCTION by trying various examples.

EXAMPLE 3: COMBING NUMBERS

We have text in the cell D9 and text in the cell E5.

We can simply do that by following the steps

  • Select the cell G7 and put the formula as
  • =CONCATENATE(D7,E7) and click ENTER.
  • The result will appear in the cell
  • The process is shown in the picture below.
google sheets concatenate
USING CONCATENATE FUNCTION IN GOOGLE SHEETS

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

YOU MAY LIKE

PREVIOUS ARTICLE
NEXT ARTICLE

LEARN

Encourage us by following at …

Facebook Twitter Pinterest

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

[email protected]

Share this:

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: