How to Combine two cells

Louis.Smith · 12/20/23

I am trying to combine the Last Name and First Name column.

Please see the formula that I used below:

=[Last Name]@row + "," [First Name]@row

KPH · 12/20/23

Try adding another plus between the comma and the second column reference.

=[Last Name]@row + "," + [First Name]@row

Louis.Smith · 12/20/23

https://community.smartsheet.com/discussion/comment/410447#Comment_410447

Perfect this worked.

Now I am struggling to pull in the emails from another sheet.

I used the formula below:

=IFERROR(INDEX({Copy of Master DPS Directory Range 1}, MATCH([Full Name]@row, {Copy of Master DPS Directory Range 2}, 0)), "")

KPH · 12/21/23

Formula looks good @Louis.Smith

What is it doing or not doing? Is there an error, or it is just not matching?

Make sure the range you have called Copy of Master DPS Directory Range 1 contains the email addresses and Copy of Master DPS Directory Range 2 contains the names in exactly the same format (i.e. surname comma firstname).

How to Combine two cells

Answers

Help Article Resources

Categories