Can anyone tell me how to create a space in a custom formula? I have created a formula to add the first name and last name in a seperate field but when the data populates there is no space between the first and last name.

For example : It looks like    JOHNSMITH instead of John Smith

Thanks so much!

Jmac6477