Excel CONCAT Function

What is CONCAT function in Excel?

The CONCAT 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 insert function Tab.

How to use CONCAT function in excel

  1. Click on 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 CONCAT function.

6. Then select ok.

excel CONCAT function

7. In function arguments Tab you will see CONCAT 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 results in formula result section.

How to use CONCAT function in excel

Examples of CONCAT function in Excel

CONCAT related functions

Leave a Reply

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