Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
For example:
Column A says "John"
Column B says "Smith"
Can column C read "John Smith"?
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.
