CONCAT Function in Google Sheets: Explained

What does the CONCAT formula do in Google Sheets?

The CONCAT function is equivalent to the “&” operator and allows you to combine two values in cells. However, you can’t include any space or other signs, marks, or values between them as you can in the CONCATENATE function. So, you should use the CONCAT formula when you want to combine two values as they are, without any space between them.

How to use the CONCAT function in Google Sheets

1. Type the equal sign (=) to begin the function, and then type CONCAT to start the function.
2. Inside the parentheses, manually type the two values separated by commas. For example, to combine the text in cells A1 and B1, you would type =CONCAT(A1, B1).
3. Press Enter on your keyboard to complete the function and display the combined text in the selected cell.

Note 1: When you enter a value manually in the formula, you need to enclose it with quotation marks.

Note 2: When you use references to cells to input values in the formula, you can’t choose a range for either of the arguments in the CONCAT formula. You only can select a single cell as an input value.

What is the difference between CONCAT and CONCATENATE functions in Google Sheets?

As we explained above, the CONCAT has limited functionality, which only allows you to combine two values as they are. With the CONCATENATE formula, you can work on values more flexibly. For example, you can insert a space between two values if you specify it in the formula, and select a range (e.g., A1:A3)  as an input value for the formula. Therefore, although the CONCAT is easy to use for its simplicity, we recommend you use the CONCATENATE function, which does what the CONCAT does and gives you more flexibility and variety in your work.

What are the other tips or formulas on text in Google Sheets?

Check the following articles if you are interested in formatting text in cells.
How to Make Text Bold, Italic, and Strikethrough in Google Sheets
How to Align Text in Google Sheets
How to Wrap Text in Cell in Google Sheets
How to Rotate Text in Google Sheets
How to Change Default Font in Google Sheets
How to Indent Texts in Google Sheets: Explained
How to Capitalize the First Letter in Google Sheets
How to Capitalize All Letters in Google Sheets
How to Make All Letters Lowercase in Google Sheets
TEXT Function in Google Sheets: Explained

Do you want to learn how to combine or split text in Google Sheets?
How to Combine Texts in Google Sheets
How to Use the CONCATENATE function in Google Sheets
How to Split Texts into Columns in Google Sheets
How to Use SPLIT Function in Google Sheets
CHAR Function in Google Sheets: Explained

Do you want to know where a specify character or word is in a text string?
LEFT Function in Google Sheets: Explained
How to Use RIGHT Function in Google Sheets
SEARCH Function in Google Sheets: Explained
FIND Function in Google Sheets: Explained

Do you need to replace a part of text with another characters or words?
How to Use REPLACE Function in Google Sheets
SUBSTITUTE Function in Google Sheets: Explained

Do you like to show a formulae in a cell?
How to Use FORMULATEXT Function in Google Sheets

This function is useful when you need to count the number of characters in a text string.
LEN Function in Google Sheets: Explained

Why don’t you double-check the spelling of your texts or cleaning up extra spaces before printing or closing Google Sheets?
How to Spell-check in Google Sheets
How to Trim Whitespaces in Google Sheets

You can repeat the same text string with this formula.
REPT Function in Google Sheets: Explained

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.