The TEXT Function
It converts numbers to a more readable text format, using format codes. It will convert numbers to text, so functions that require a numeric value will not be able to use the converted one.
2204, 2019
Category Archives: Functions
2204, 2019
The T Function
It returns a text referred by a given value.
2204, 2019
The SUBSTITUTE Function
It searches for a specific text in string and replaces it with another. It is a case-sensitive function.
2204, 2019
The RIGHT Function
It returns a given amount of characters from the end of a string.
2204, 2019
The REPT Function
It repeats a specific text a given number of times.
2204, 2019
The REPLACE Function
It replaces part of a string, based on a start position and number of characters you specify, with a different string.
1904, 2019
The PROPER Function
It capitalizes the first letter of each word and converts the rest of the letters to lowercase.
1904, 2019
The MID Function
It returns a specific amount of characters from a string, starting at a specific position in the string.
1904, 2019
The LOWER Function
It converts all letters in a string to lowercase.
1904, 2019
The LEFT Function
It returns a certain amount of characters from the beginning of a string.
