2 Replies Latest reply on Jul 31, 2015 6:02 AM by Julie284

    Full Name Calculation - leaving out spaces

    Julie284

      Title

      Full Name Calculation - leaving out spaces

      Post

       

       

      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!