### 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.

Hi,

Just add a space between quotation marks:-

Last_First_Middle= Last Name & ", " & First Name & " " & Middle Initial

Please note that this will add an extra space to the end of the text field if the Middle Initial is empty. If you plan on using this field in a letter or email, this may not look right. If this is a concern, post back for a more complex calculation.