Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Owner
  • Admin
  • Editor

Combine (concatenate) text or values from two or more cells with a simple formula

You can combine multiple cells to join values together in a text chain or series.

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin
  • Editor

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Users on an Enterprise plan can use AI to generate formulas. Learn more.

Users with Editor sharing permissions can only create and edit formulas in unlocked cells on a sheet.

Create a simple formula to concatenate text

If you want to combine text from two or more cells into a different cell (concatenate the values), you can do this with a simple formula.

  1. Click in the cell in which you want the result.
  2. Press = (the equal sign).
  3. Click the first cell that you want to refer to in the join and then press + (the plus sign).
  4. Click the second cell that you want to refer to (to join the values together) and press Enter.

To get a sense of the possible ways you can combine cell data, see the examples below.

 

As an alternative, you can use the JOIN function to combine cell values into a text string. Learn more about the JOIN Function.

 

Concatenation formula examples 

In the following examples, assume that [Task Name]1 contains the text "First Task" and [Task Name]2 contains "Second Task."

= [Task Name]1 + " " + [Task Name]2

Result: First Task Second Task

When you join cell values, you can use delimiters to separate the values in the range:

= [Task Name]1 + "-" + [Task Name]2

Result: First Task-Second Task

= [Task Name]1 + "," + [Task Name]2

Result: First Task,Second Task

If no delimiter value is included, the values from the range will be joined without spaces:

= [Task Name]1 + [Task Name]2

Result: First TaskSecond Task

 

Still need help?

Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community

Was this article helpful?
YesNo