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.
