Trim ( Self ) will remove leading and trailing spaces when you use this as an auto-entered calculation. Make sure to also clear the "do not replace existing value..." check box as well.
I often use TextFormatRemove ( Trim ( Self ) ) as a way to remove extra spaces and also to prevent the user from either pasting formatted text (mac users) or from using FileMaker's format bar (both platforms) to format the text in the field.
Great ... Thanks