- PROPER
It is used to make the given input in proper case. It can be used to capitalize each word in a given string.
2. Text to Columns
It is used to separate the contents of one cell into separate cells.
3.SUMIF
It will sumup the cells that meet certain criteria.
formula : =SUMIF(range , criteria , [sum_range])
Below are the arguments in SUMIF function:-
a) range : The range of cells that you want to apply thecriteria against.
b) criteria : The criteria is used to determine which cells to add.
c) sum_range (optional) : The range of cells to sum.
4. TRIM
It removes the unwanted space between the characters.
5. LEFT
It is used to get the leftmost character.
formula : =LEFT ( text, criteria )
6. RIGHT
It is used to get the rightmost character
formula : =RIGHT ( text , criteria)
7. MID
It is used to get the middlemost character.
formula : =MID(text , start_num , num_chars)