Return a number of spaces.
Syntax Space(Number) Key Number The number of spaces to return.
The Space() function may be used in VBA or in an SQL query.
Dim strDemo as String
strDemo = Space(5)
'Returns: " "
“Empty pockets never held anyone back. Only empty heads and empty hearts can do that” ~ Norman Vincent Peale
RTrim - Remove trailing spaces from a string.