Arrow left
Back to product guides
Google Sheets Formulas

How to Use the CONCATENATE function in Google Sheets

In this article, you will learn how to combine texts with the CONCATENATE formula in Google Sheets. The function is beneficial when you need to connect values in different cells. This function works similarly to the “&” mark, which is also used to combine texts in Google Sheets.

How to use the CONCATENATE formula in Google Sheets

  1. Type “=CONCATENATE” or go to “Insert”“Function” “Text”“CONCATENATE”.
  2. Select values you want to combine and input texts manually in the formula, if necessary.
  3. Press the “Enter” key.
How to insert the CONCATENATE function in Google Sheets

The general formula is as follows:

=CONCATENATE(string1, [string2, …])

String1: This is a value you want to connect with other values. You can use cell reference or manually input. You should punctuate them by inserting a comma between the two values.

See the following picture to understand how the formula works.

How the CONCATENATE formula works in Google Sheets with examples

Example #1:  This example shows how you can use the formula only with manual input. You need to follow the general manual input rules (e.g., enclosing a date with quotation marks, etc.)

Example #2: This example represents combining two cell values by cell reference.

Example #3: As you may be aware in the second example, this function does not provide spaces between the values as default; you need to insert “ “ as an input in the formula or refer to a cell containing a space instead.

Example #4: The fourth example shows how to combine more than two values and incorporate a formula as an input value. As a cell containing a date is recognized as a number, you need to use the TEXT function to keep the date format in the output.

Example #5: The last example shows that you can refer to cells in the order you want. In the formula, “Value 3” is referred to secondly, and “Value 2” is done so thirdly (except for two spaces).

How do I combine text in Google Sheets in another way?

Check this article on how to connect two or more values with the “&” mark.

What are the other tips on text in Google Sheets?

Check the following articles if you are interested in formatting text in cells.

How to Indent Texts in Google Sheets: Explained

How to Wrap Text in Cell in Google Sheets

How to Capitalize All Letters in Google Sheets

How to Make All Letters Lowercase in Google Sheets

How to Capitalize the First Letter in Google Sheets

How to Align Text in Google Sheets

Do you want to learn how to combine or split text in Google Sheets?

How to Combine Texts in Google Sheets

How to Split Texts into Columns in Google Sheets

How to Use SPLIT Function in Google Sheets

Why don’t you double-check the spelling of your texts before printing or closing Google Sheets?

How to Spell-check in Google Sheets

Analyze your live financial data in a snap

Are you learning this tip to build a financial KPI dashboard? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711