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
- Click on 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 CONCAT function.
6. Then select ok.
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.
Examples of CONCAT function in Excel
CONCAT related functions
- Use CONCATENATE function to concatenate a list or range of text strings.
- TEXTJOIN function
