Full Name Calculation - leaving out spaces
I'm sure this is an easy one for most of you, but I'm a novice at this and having some problems understanding how connectors and calculations work. I couldn't find the answer on the forum or google, so hope someone can help me out.
I want to make a FullName calculation, which includes a first name, prefix and last name. However, in many cases, the prefix is empty, which in my case ends up giving me 2 spaces in between first and last name. There must be an easy solution to leaving out the Prefix and space, when Prefix field is empty. My calculation now is:
FirstName & " " & Prefix & " " & LastName
Thanks for your help!