SPACE(number)

Returns the specified number of spaces (String).


numberThe number of spaces you want in the text string.

REMARKS
* This function is useful for formatting output and clearing data in fixed-lengths strings.
* You can use the SPACE$ function to return a String data type instead of a Variant/String data type.
* The equivalent .NET function is Microsoft.VisualBasic.Strings.Space
* For the Microsoft documentation refer to docs.microsoft.com

sText = Space(25) 
sText = " ' " & Space(10) & " ' "
Space(10) = " "
Space(-1) - runtime error
Space("text") - runtime error


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top