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
Check out the Formula Handbook template!