Tag Archives: Text Functions

The TRIM Function

Kornilios Ampatzis/ April 22, 2019/ Functions

Removes all the spaces from the text except the single spaces between words.

The TEXT Function

Kornilios Ampatzis/ April 22, 2019/ Functions

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.

The SUBSTITUTE Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It searches for a specific text in string and replaces it with another. It is a case-sensitive function.

The RIGHT Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It returns a given amount of characters from the end of a string.

The REPLACE Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It replaces part of a string, based on a start position and number of characters you specify, with a different string.

The PROPER Function

Kornilios Ampatzis/ April 19, 2019/ Functions

It capitalizes the first letter of each word and converts the rest of the letters to lowercase.