Can you concatenate in SS?

Erica Ringer

For example:

 

Column A says "John"

Column B says "Smith"

 

Can column C read "John Smith"?

J. Craig Williams

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

Fran Warner

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)

Fran Warner

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