FORMULA LANGUAGE


Trimming, repeating, adding a new line, and changing case
Example

The following @functions trim strings, repeat characters, add a new line (carriage return), and change case:

FunctionDescription
@LowerCase(string)Converts all uppercase characters in a string to lowercase.
@NewLineInserts a new line (carriage return) into a text string.
@ProperCaseConverts the first character of each word in a string to uppercase and the remaining characters to lowercase.
@Repeat(string , number)Repeats a string a number of times.
@Trim(string)Removes leading, trailing, and redundant spaces from a string.
@Trim(list)Removes leading, trailing, and redundant spaces from each element of a string list, and removes blank elements from the list.
@UpperCase(string)Converts all lowercase characters in a string to uppercase.

Example
See Also