Space(number) ‘number is number of spaces
'example MsgBox ("First" & Space(2) & "Second" & Space(20) & "Last")
Space(number) ‘number is number of spaces
'example MsgBox ("First" & Space(2) & "Second" & Space(20) & "Last")
‘Method 1 Trim(<string variable>) ‘Method 2 LTrim(<string variable>) RTrim(<string variable copy after left trim>)