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"