How to combine two rows of non-numerical Data?

Options

I am working on a project where I learned that the clients first name and the clients full name will be required. I currently have a column for first name and a column for last, and I would like to combine those two to create a full name column. I tried adding both of them together, which worked but didn't include a space in the name. I also tried the JOIN function, and I wasn't able to get the formula to work. Any help would be appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!