How to combine two rows of non-numerical Data?


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!