( [Surname],+" "+LTRIM([First Name]))
This was for your Calc, which I don't feel something good about ,
Isn't it should be:
[Surname]+","+" "+LTRIM([First Name])
If there are possibilities of spaces in surname also, You may want to trim that too..
TRIM([Surname])+","+" "+TRIM([First Name])
Also i think TRIM will be a better function as it will trim both leading and trailing white spaces.
You can try below logic:
TRIM([Surname])+", "+TRIM([First Name])
Here, TRIM will remove any leading and trailing space that's there in the "SURNAME"/FIRST NAME.