Adding a space in a value list will actually add a space into the data itself. It is better to handle the issue in the DISPLAY of your data. One way would be to concatenate all your fields involved in the name and then wrap with TrimAll().
To clarify, if you only want to remove the extra beginning or ending space, you can use Trim(). But let's say that you have:
Title & " " & FirstName & " " & MiddleName & " " & LastName
If you use TrimAll ( aboveCalc ; 1 ; 1 ) then if no middle name, you won't get double spaces between FirstName and LastName. So it protects from double spaces in the middle AND begin and end spaces.