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”)
0 Comments