ALL TEXT FUNCTIONS

CLEAN : Removes the non-printable characters and line breaks in a string

CONCATENATE : Joins several text strings into one.

EXACT : Compares two strings   

FIND : Finds the location of one text string inside another string

FIXED : Rounds a number to a specified number of decimals and returns it as a text with or without commas.

LEFT : Extracts a specified number of characters from a string starting from the left

LEN : Returns the length of the string as number

LOWER : Converts all characters of a string to lower case.

MID : Extracts a specified number of characters from a string starting from a specified number of characters away from the left

 PROPER : Converts all words of a string to proper case.

REPLACE : Replaces a part of a string with another           

RIGHT : Extracts a specified number of characters from a string starting from the right

SEARCH : Returns the location of one text inside another text

SUBSTITUTE : Replaces a set of characters with another

TEXT : Converts a number into a desired text format

TRIM : Removes extra spaces in a string

UPPER : Converts all characters of a string to upper case.

VALUE : Converts a number stored as text or number within quotes to a valid number