Excel CONCATENATE Function

What is CONCATENATE function in Excel?

The CONCATENATE function is one of the TEXT functions of Excel.

It Concatenates a list or range of text strings.

We can find this function in TEXT category of the insert function Tab.

How to use CONCATENATE function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select TEXT category.

5. Select CONCATENATE function

6. Then select ok.

excel CONCATENATE function

7. In function arguments Tab you will see CONCATENATE function.

8 .Text1,text2,… are 1 to 254 text strings or ranges to be joined to a single text string.

9. You will see the result in the formula result section.

How to use CONCATENATE function in excel

CONCATENATE related functions

  • Use CONCAT function to concatenate a list or range of text strings.
  • TEXTJOIN function

Leave a Reply

Your email address will not be published. Required fields are marked *