The VALUE Function
It converts a text that represents a number to that number.
2204, 2019
Tag Archives: Text Functions
2204, 2019
The UPPER Function
It converts all the text to uppercase.
2204, 2019
The TRIM Function
Removes all the spaces from the text except the single spaces between words.
2204, 2019
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
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.
