Anaplan provides a range of functions that enable you to work with text.

Text-formatted values enable you to collaborate with and capture insights from people who use the models you build. Use the text functions available in Anaplan to effectively work with this data.

You can use text functions to extract strings from text, find specific characters, concatenate text values, convert values to text, and more. See the full list of text functions in the table below.

Title Description

The FIND function searches for the first occurrence of a text value within another one. If the text contains the specified characters, the function returns a number. This number indicates the position of the first occurrence of the text value searched for.


Extracts a string of characters from text, starting from the left.


The LENGTH (or LEN) function returns the number of characters in a text string.


The LOWER function converts text values to lowercase.


Use the MAILTO function to generate clickable links that send an email. You can specify recipients, subjects, and body text.


The MAKELINK function generates clickable links in a module.


Extracts a number of characters from a text string, starting from a character you select.


Use the NAME function to convert data from a list item to text.


Extracts a string of characters from text, starting from the right. 


The SUBSTITUTE function finds all occurrences of a text value within another one, and replaces them with a given value.


The TEXT function converts numeric values to text.


The TEXTLIST function concatenates a series of text values into a single text value.


The TRIM function removes all leading and trailing spaces, and extra spaces between words in a text string.


The UPPER function converts text values to uppercase.


We update Anapedia regularly to provide the most up-to-date instructions.