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?
For example:
Column A says "John"
Column B says "Smith"
Can column C read "John Smith"?
Comments
-
Yes.
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
John
Smith
I hope this helps.
Craig
-
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.
