Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Can you concatenate in SS?

Erica Ringer
edited 12/09/19 in Archived 2016 Posts

For example:


Column A says "John"

Column B says "Smith"


Can column C read "John Smith"?


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 07/07/16



    Use the "+" sign


    =[Column A]23 + " " + [Column B]23


    for row 23.

    The " " adds the space between them


    result will be 


    John Smith.


    You didn't ask, but there isn't a way to add a line feed so that the result would be





    I hope this helps.



  • Fran Warner
    edited 10/06/16

    Same subject, different scenario - I have a column for First Name and one for Last Name.  Using my name as an example, I want the result "Fran W".  To solve, I first added a column to get the W of my last name by using LEFT().  That works fine.  Now I want to concatenate First Name + Last Name Initial, however I'm getting the result #UNPARSEABLE.  What am I doing wrong????  Here's the formula I'm using:


    =concatenate([First Name]4+" "+[Init of Last]4)

  • hah - I solved it.  Had to use "join," not concatenate.


This discussion has been closed.