<< Click to Display Table of Contents >> Navigation:  String functions > Space or Space$

Description

Returns a string consisting of the specified number of spaces.

Syntax

Space(number) or Space$(number)

 

The number argument is the number of spaces you want in the string.

Remarks

The following example uses the Space function to return a string consisting of a specified number of spaces:

 

Dim MyString

MyString = Space(10)                     ' Returns a string with 10 spaces.

MyString = "Hello" & Space(10) & "World" ' Insert 10 spaces between two strings.