String format examples

The following table contains template examples of string formats.

Tip: The ¤ characters in this table represent spaces.

 

Template formula

Returns this string

Display all characters as uppercase

FORMAT 'Hello World', '>'

HELLO WORLD

Display value as a specific number of characters
(right-justified)

FORMAT 'Hello World', '@@@@@@@@@@@@@@@'

¤¤¤¤Hello World

Display value as a specific number of characters
(left-justified)

FORMAT 'Hello World', '!@@@@@@@@@@@@@@@'

Hello World¤¤¤¤

Add characters to the value
(filling from right to left)

FORMAT 'Hello World', '\"&&&&&\"'

Hello "World"

 

More:

String formats