AnsweredAssumed Answered

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

Question asked by bms3122 on Apr 12, 2009
Latest reply on Apr 13, 2009 by Jade

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.

Outcomes