| =LEN() | =CONCATENATE() | =CONCAT() | =EXACT() | =UPPER() | |
| =LOWER() | =PROPER() | =LEFT() | =RIGHT() | =MID() | |
| =CHAR() | =FIND() | =REPLACE() | =TRIM() | =TEXTJOIN() | |
| =TEXT() | =SEARCH() | =REPT() | =SUBSTITUTE() | =CODE() |
=LEN()
This function calculate the length of the text.
Syntax: =LEN(text)
Ex: =LEN("Computer") >> Output: 8
=CONCATENATE()
This function calculate the length of the text.
Syntax: =CONCATENATE(text1, text2, ....)
Ex: =CONCATENATE("Siku", " ", "Gon") >> Output: Siku Gon
=CONCAT()
This function concatenate a list or range of text.
Syntax: =CONCAT(text1, text2, ....)
Ex: =CONCAT("I", " ", "am") >> Output: I am
=EXACT()
This function match two texts, if both text are match, it returns true otherwise it returns false.
Syntax: =EXACT(text1, text2)
Ex: =EXACT("Siku" , "Miku") >> Output: False
=UPPER()
This function converts the lower case word to upper case.
Syntax: =UPPER(text)
Ex: =UPPER("siku") >> Output: SIKU
=LOWER()
This function converts the upper case word to lower case.
Syntax: =LOWER(text)
Ex: =LOWER("SIKU") >> Output: siku
=PROPER()
This function converts the word to proper case i.e. first letter capital and others are small.
Syntax: =PROPER(text)
Ex: =PROPER("SIKU") >> Output: Siku
=LEFT()
This function displays the number of characters from the left side of a text.
Syntax: =LEFT(text, [num_of_char])
Ex: =LEFT("Siku", 2) >> Output: Si
=RIGHT()
This function displays the number of characters from the right side of a text.
Syntax: =RIGHT(text, [num_of_char])
Ex: =RIGHT("Siku", 2) >> Output: ku
=MID()
This function displays the number of characters from the right side of a text.
Syntax: =MID(text, start_num, num_chars)
Ex: =MID("siku",1,3) >> Output: Sik
=CHAR()
This function displays the character of a given code.
Syntax: =CHAR(number)
Ex: =CHAR(65) >> Output: A
=CODE()
This function displays the code of a given character.
Syntax: =CODE(text)
Ex: =CODE(A) >> Output: 65
=FIND()
This function find the location of certain text.
Syntax: =FIND(find_text, within_text, [start_no.])
Ex: =FIND("k", "Siku") >> Output: 3
=REPLACE()
This function replace the letter of a given word.
Syntax: =REPLACE(text)
Ex: Replace 0000 to year which is in B column.
=REPT()
This function repeats the text upto specified number of time.
Syntax: =REPT(text, number of times)
Ex: =REPT("Om ", 3) >> Output: Om Om Om
=TRIM()
This function removes all spaces from a text string except single space between words.
Syntax: =TRIM(text)
Ex: =TRIM("I am siku") >> Output: I am siku
=TEXTJOIN()
This function join the two texts.
Syntax: =TEXTJOIN(delimiter, ignore_empty, text1, ...)
Ex:
=TEXT()
This function converts a value to a text.
Syntax: =TEXT(value, format_text)
Ex: =TEXT("1-1-1999", "DD-MM-YYYY") >> Output: 01-01-1999
=SEARCH()
This function returns the number of the chars in a string.
Syntax: =SEARCH(find_text, within_text, [start_no.])
Ex: =SEARCH("n", "orange") >> Output: 4
=SUBSTITUTE()
This function replace the old text from with new text.
Syntax: =SUBSTITUTE(text, old_text, new_text)
Ex: =SUBSTITUTE("9180284 50850","91","+91 ") >> Output: +91 80284 50850