What is the syntax to fill a string with spaces?

Space(number)
‘number is number of spaces
'example
MsgBox ("First" & Space(2) & "Second" & Space(20) & "Last")

unnamed (5).jpg

 

 

Advertisements

What is the syntax to remove spaces from beginning/end of string?

‘Method 1
Trim(<string variable>)

‘Method 2
LTrim(<string variable>)
RTrim(<string variable copy after left trim>)