4 Replies Latest reply on Apr 13, 2009 5:38 AM by Jade

    Calculation formula for Last Name, First Name, Middle Initial. I'm stuck!

    bms3122

      Title

      Calculation formula for Last Name, First Name, Middle Initial. I'm stuck!

      Post

      I need to write a calculation field formula yielding a text result for last name, first name and middle initial.

       

      My problem is that I need to generate one space between the last letter of the first name and the middle initial. 

       

      My formula works fine for last and first name, as follows: Last_First=   Last Name & ", " & First Name. The result I get from my data is Doe, John. So far so good. 

       

      But I need to add a middle initial. So I changed the formula to Last_First_Middle= Last Name & ", " & First Name & Middle Initial.  The result I get is Doe, JohnX.  Ask you can see, I need a space between "John" and "X" (where X is the middle initial.)

       

      Is there a text operator for inserting a space into this formula ???   Or any other way to achieve this result ???

       

      Your help is much appreciated.