Space

Creates a String consisting of the specified number Num of spaces. The Space function is useful for formatting output and clearing data in fixed-length strings.

Syntax

Space(Num)

Num:

An Integer or expression representing a valid numeric value.

Return Value

Returns a Variant containing a String data type.

Related Functions

String

Example

Dim strTest as String

' Returns a string with 10 spaces.

strTest = Space(10)



' Insert 10 spaces between two strings.

strTest = "Hello" & Space(10) & "World"