Hi, I have 5 fields, Company; Title; Forename; Othername and Surname, and I want to join them together. I've created a formula field, companypersonname, and used the following formula:
TRIM({Company}&" "&{Title}&" "&{Forename}&" "&{Othername}&" "&...