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
- Click on an empty cell (like F5).

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

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

4. Select TEXT category.
5. Select CONCATENATE function
6. Then select ok.

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.

CONCATENATE related functions
- Use CONCAT function to concatenate a list or range of text strings.
- TEXTJOIN function