Use Excel's text functions in your Anaplan XL reports
| Function | Description |
| CHAR | Returns the character specified by a number. |
| CLEAN | Removes all nonprintable characters from text. |
| CODE | Returns a numeric code from the first character in a text string. The opposite of the CHAR function. |
| CONCATENATE | Joins several text strings into one text string. |
| DOLLAR | Converts a number to text using Currency format, with the decimals rounded to the specified place. |
| EXACT | Compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise. |
| FIND | Locates one text string within another text string, and returns the number of the starting position of of FIND_TEXT from the leftmost character of WITHIN_TEXT. |
| FINDB | Returns the position of specified text within another specified text string based on the number of bytes each character uses from the first character of WITHIN_TEXT. |
| FIXED | Rounds a number to a specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. |
| LEFT | Returns the first character(s) in a text string. |
| LEFTB | Returns the first character(s) in a text string based on a specified number of bytes. |
| LEN | Returns the number of characters in a text string. |
| LENB | Returns the number of characters in a text string expressed in bytes. |
| LOWER | Converts all letters in a text string to lowercase. |
| MID | Returns a specific number of characters from a text string starting at the position you specify. |
| MIDB | Returns a group of characters based on a specified number of bytes from a text string starting at the position you specify. |
| NUMBERVALUE | Converts the specified text to a number using the specified decimal separator and thousands separator. |
| PROPER | Capitalizes the first letter of each word in a text string or sentence. |
| REPLACE | Replaces part of a text string with a different text string based on the number of characters you specify. |
| REPLACEB | Replaces part of a text string with a different text string based on the number of characters you specify in terms of bytes. |
| REPT | Repeats the specified text a given number of times. |
| RIGHT | Returns the last character(s) in a text string. |
| RIGHTB | Returns the last character(s) in a text string based on a specified number of bytes. |
| SEARCH | Returns the number of the character at which a specific character or text string is first found, reading from left to right. |
| SEARCHB | Returns the number of the character at which a specific character or text string is first found in bytes, reading from left to right. |
| SUBSTITUTE | Substitutes NEW_TEXT for OLD_TEXT in a string. |
| T | Returns the text referred to by a value. |
| TEXT | Converts a value to text in a specific number format. |
| TRIM | Removes all spaces from text except single spaces between words. |
| UNICHAR | Convert the specified UTF-32 code point to text. |
| UNICODE | Convert the first character in the specified text to a UTF-32 code point. |
| UPPER | Converts text to uppercase. |
| USDOLLAR | Converts a number to text using U.S. Dollar format, with the decimals rounded to the specified place. |
| VALUE | Converts a text string that represents a number to a number. |
