Text Function
CHAR | CODE | UNICHAR | UNICODE | CLEAN | TEXT | NUMBERVALUE | FIXED | DOLLAR | T | VALUE | LEN | LEFT | RIGHT | MID | REPT | EXACT | CONCATENATE | TRIM | LOWER | UPPER | PROPER | FIND | REPLACE | SEARCH | SUBSTITUTE
6.1) CHAR: - This function required number between 1 to 255 specifying which character you want. The character is from the character set used by your computer
Syntax: =
Example
6.2) CODE: - This function returns the ASCII value of a character, this function return character number
Syntax: =
Example
6.3) UNICHAR: - This function give you the Unicode characters from the Unicode number provided.
Syntax: =
Example
6.4) UNICODE: - This function give you Unicode of string/texts
Syntax: =
Example
6.5) CLEAN: - Remove non-printable characters (Non-printable Unicode characters include No. 1429,141,143,144 & 157)
Syntax: =
Example
6.6) TEXT: - The easiest way to change number to text
Syntax: =
Example
6.7) NUMBERVALUE: - This function is use to change text value to number with decimal and group separators.
Syntax: =
Example
6.8) FIXED: - This function apply decimal points with prevent commas or do not prevent commas to any number,
Syntax: =
Example
6.9) DOLLAR: This function change the number to text with currency format with the decimals place round as per you specify.
Syntax: =
Example
6.10) T: - This function check the text/string
Syntax: =
Example
6.11) VALUE: - This function give you a numeric value
Syntax: =
Example
6.12) LEN: - This function use to counts characters, letters and space in the cells (Count the length of text)
Syntax: =
Example
6.13) LEFT: - This function is used to extract left side’s number of text
Syntax:=
Example
6.14) RIGHT: - This function is used to extract right side’s number of text
Syntax: =
Example
6.15) MID: - Return the character of given number from middle of a supplied text string
Syntax: =
Example
6.16) REPT: - This function give you repetitive text as per specified number to times.
Syntax:=
Example
6.17) EXACT: - This function used for check or compare both text are same or not, consider upper and lower case also (Result in True or False)
Syntax: =
Example
6.18) CONCATENATE: - This function joint multiple character and values in on word
Syntax:=
Example
6.19) TRIM: - This function remove unwanted starting and ending space
Syntax:=
Example
6.20) LOWER: - change text case in lower case
Syntax: =
Example
6.21) UPPER: This function is used to change text case in capital (upper case)
Syntax: =
Example
6.22) PROPER: - This function is used to change text case in first letter in capital then small case.
Syntax: =
Example
6.23) FIND: - This function is use to find out text number within any word from starting position, consider upper & lower case also
Syntax: =
Example
6.24) REPLACE: - This function is used to replaces character specified by position in given text string with another text string
Syntax:=
Example =Replace (“Vikas123”, 6, 3,”456”) Vikas456
6.25) SEARCH: - This function returns a number value. The first position.
Syntax: =
Example
6.26) SUBSTITUTE: - This function is replace a group of string with another string.
Syntax: =
Example
