How to combine two rows of non-numerical Data?

cmc484

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.

JamesB

@cmc484 Try this

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

Paul Newcome

Have you tried adding in a space when adding the two names together?

=First@row + " " + Last@row