From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Use CONCATENATE function in MS Excel

What is CONCATENATE function in 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.

Description

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.

Struggling with your Excel formulas?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free

Syntax

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.

CONCATENATE Function Example in Excel

CONCATENATE MS Excel function explained - Ajelix excel formula cheat sheet - formulas and functions
In the picture above you can see the function used to match Name and Surname in one cell.

Function Example Result in Excel

CONCATENATE MS Excel function the result of the formula - explained - Ajelix excel formula cheat sheet - formulas and functions
You can see that function combined both of the cells in one string. Keep in mind that you can use this function to combine unlimited count of the cells in one string.

Bonus Example

CONCATENATE MS Excel function bonus example - explained - Ajelix excel formula cheat sheet - formulas and functions
In the screenshot above you can see the same CONCATENATE function with added space sign (” “) between both cells. The function now will add space between words, you can use this trick with different signs such as commas, semicolons, just make sure to insert it in quotes.

How to use CONCATENATE function MS Excel in your workbook:

  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.

Frequently Asked Questions

What is CONCATENATE function in Excel?

The CONCATENATE function in Excel is used to join two or more text strings together. It can be used to combine data from multiple cells into one cell, or to join text strings inside a single cell. It can also be used to add static text to a cell, such as adding a space or punctuation.

How does CONCATENATE work in Excel?

CONCATENATE function is used to join two or more text strings together. It takes two or more string arguments, and returns a single string with the original strings combined. The syntax for the CONCATENATE function is CONCATENATE(text1, [text2], [text3], …).

How to enter a CONCATENATE formula?

To enter a CONCATENATE formula, type “=CONCATENATE(text1, text2, …)”, where “text1, text2, …” should be replaced by the text or cell references that you want to combine.

Read latest blog articles about Excel

WEEKLY BLOG ARTICLES WITH INDUSTRY NEWS AND HELPFUL GUIDES

How To Add Drop Down List in Excel

How To Add Drop Down List in Excel

Continue reading

How To Add Checkboxes In Excel

How To Add Checkboxes In Excel

Continue reading