Space Function

Returns a Variant (String) consisting of the specified number of spaces.


Space( number )

The required numberargument is the number of spaces you want in the string.


The Space function is useful for formatting output and clearing data in fixed-length strings.


Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the Space function to return a string consisting of a specified number of spaces.

Dim MyString
' Returns a string with 10 spaces.
MyString = Space(10)
' Insert 10 spaces between two strings.
MyString = "Hello" & Space(10) & "World"
Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!