I have one field that I would like to generate from three other ones: First Name, Middle Name, and Last Name. My current formula includes a space after each cell so that it reads Jane Doe Smith versus JaneDoeSmith. The problem I have is if the middle...