- Containing cell: enter the containing cell containing the character string to count.
For example: To count the number of characters in the string "taivn20146sgn*" in cell D8, we have the syntax =LEN(D8) in the formula cell, the number of characters 14 will be returned in the LEN function cell.
8. TRIM() function
Removes blank characters that exist at both ends of the string.
Syntax: = TRIM(Containing cell)
- Cell containing: enter into the cell containing a string of characters with characters that appear at both ends of the string
For example: In the cell containing D8, there is the string "taivn20146sgn*" with blank characters at both ends of the string. To remove this blank character, we have the syntax =TRIM(D8) to get "taivn20146sgn*" in the TRIM Function column. in an Excel spreadsheet
Above is a summary of functions that process character strings in Excel, syntax and examples to help you grasp the uses of the functions and how to use them. But this function will bring high efficiency when you need to process large data series and solve the job quickly.
In addition, before learning more in-depth functions of Excel, you should also refer to the basic functions in Excel to know how to use basic functions such as MAX, MIN. as well as equipped with other tools. Necessary tools when using this office software.