Text Functions in LibreOffice Calc

Text Functions –

There are many Text function used in LibreOffice Calc some are-

Left: This Function is used to display the specified numbers of characters from the left side of a text string. 

=Left(“it computer guruji” ,3)

Right: This Function is used to display the specified numbers of characters from the right side of a text string. 

=Right(“it computer guruji” ,6)

Mid: This function is used to display the specified numbers of characters from the middle of a text string position and length. 

=Mid(“it computer guruji” ,2,2)

Proper: This function is used to converts the first letters of each word in a text string to upper case just like Title case and remaining letter to lower case. 

=Proper(“it computer guruji”)

Lower: Function is used to convert all upper Case in the text string to lower case. 

=lower(“IT Computer Guruji”)

Upper: Function is used to convert all lower case letters in a text string to upper case. 

=upper (“it computer guruji”) 

Len: This Function is used to display the length of a text string (Numbers of character in a text string with space) spaces are counted as characters. 

=Len(it computer guruji)

Rept: Function is used to repeat the given text to a specified numbers of times. 

=Rept(“*” ,6)

Char: - It is used for return the ASCII character from the code.  

=char (65)

Code:- It returns ASCII code of the character. 

=code (“A”)

Concatenate: - It is used for joins the two or more strings. 

=concatenate (“hello"," ", “world”) 

Trim: - It is used for remove the extra spaces.  

=trim(“hello               India”)