TRIM
Excel TRIM function will remove all unnecessary space in given text. TRIM function can only remove regular space(ASCII CODE 32).
Syntex
=TRIM(text)
Arguments
Text – word, sentence, paragraph etc
For more details on TRIM function
PROPER
Excel PROPER function will covert first character of given word to capital letter and remaining to small letter and if sentence like structure is given then it will convert all words first character capital and remaining to small.
Syntex
=PROPER(text)
Arguments
Text – word, sentence, paragraph etc
UPPER
Excel UPPER function will convert given text to capital letters.
Syntax
=UPPER(text)
Arguments
Text – word, sentence, paragraph etc
LOWER
Excel LOWER function will convert given text to small letters.
Syntax
=LOWER(text)
Arguments
Text – word, sentence, paragraph etc
LEN
Excel LEN function will provide you a number of character in given text including space.
Syntax
=LEN(text)
Arguments
Text – word, sentence, paragraph etc
LEFT
Excel LEFT function will provide the character from left side of given text. And if the second optional argument is not justified then function give you a left first character from given text.
Syntax
=LEFT(text,[num_chars])
Arguments
Text – word, sentence, paragraph etc
Optional argument[num_chars] – number of character need to specify how much character we need in output from left side
RIGHT
Excel RIGHT function will provide the character from right side of given text. And if the second optional argument is not justified then function give you a right single character from given text.
Syntax
=RIGHT(text,[num_chars])
Arguments
Text – word, sentence, paragraph etc.
Optional argument[num_chars] – number of character need to specify how much character we need in output from right side
MID
Excel MID function will provide middle characters from given text.
=MID(text,start_num,num_chars)
Arguments
Text – word, sentence, paragraph etc
Start_num – location of character in number of which we need as a first letter of our final text.
Num_chars – Number of character up to which we need text.
CONCATENATE
Excel CONCATENATE is use to join text from two different cells
Syntax
=CONCATENATE(text1,[text2],[text3]...)
Arguments
Text1 – word, sentence, paragraph etc.
[text2],[text3]...- word, sentence, paragraph etc.
