Category: Excel Function

The LOWER function converts all uppercase letters in a text string to lowercase, and keep other characters as they are. For example, "LOWER Function" will be converted to "lower …

The LENB function counts the number of bytes including spaces in a text string. When a double-byte character set (DBCS, e.g., Japanese, Simplified Chinese, Traditional Chinese and Korean) is …

The LEN function is to count the number of characters including spaces in a text string. Formula: =LEN(text) Explanations: Text is required, the text string that you need to …

The LEFTB function returns the bytes you specified in a text string. When a double-byte character set (DBCS, e.g., Japanese, Simplified Chinese, Traditional Chinese, and Korean) is set as …

The LEFT function is to return the characters you specified in a text string. Formula: =LEFT(text, ) Explanations: Text is required, the text string that contains the characters you …

The FIXED function returns numbers as text with the specified number of decimals. Formula: =FIXED(number, , ) Explanations: The Number is required, the number that you need to convert …