AnsweredAssumed Answered

Full Name Calculation - leaving out spaces

Question asked by Julie284 on Jul 31, 2015
Latest reply on Jul 31, 2015 by Julie284


Full Name Calculation - leaving out spaces




Dear all,

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!