Menu

CONCATENATE FUNCTION STICKS OR JOINS ANY TWO OR MORE GIVEN MIX OF TEXTS OR NUMBERS.

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.

**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

- 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.

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

- 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.

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

- 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.

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

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.