Calculation formula for Last Name, First Name, Middle Initial. I'm stuck!
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.