How To Use CONCATENATE function in MS Excel

CONCATENATE function allows users to combine two or more values together. It takes multiple strings of text, numbers, or cell references and joins them together into one string.

The CONCATENATE function MS Excel is used to join two or more text strings together. It takes two or more arguments, each of which can be a string, cell reference, or formula result. The function returns a single string that combines the text from separate arguments. It is helpful for combining data from multiple sources into one cell.

For example, if you have a first name in one column and a last name in the next column, you can use this function to join them into one cell. Additionally, you can use it to combine several other types of data, such as numbers, symbols, and dates.

Syntax: =CONCATENATE(text1, [text2], …)

(text1, [text2], …), where the text1 argument is required, and the text2 argument is optional. If more than two strings are given, each additional string should be separated by a comma. The function will return the combined text string.

1. Open the Microsoft Excel program on your computer.
2. Select the cell or cells you want to concatenate.
3. Click the “Formulas” tab on the ribbon.
4. Click the “Text” option in the “Function Library” group.
5. Select the “CONCATENATE” option from the drop-down menu.
6. Enter the cell addresses or text arguments in the “Reference” field. Separate each cell or argument with a comma.
7. Click the “OK” button.
8. The concatenated text should now appear in the cell you selected in step two.