The 'LEN' function in MS-Excel belongs to which of following categories?

The correct answer is Text.

• The 'LEN' function in MS-Excel belongs to text.

Key Points

• LEN function in excel is taken from the length and is used to count the number of characters is there in a cell.
• It considers special characters, spaces and alphabets and counts all these values if there is a selected cell.
• LEN function only counts the character length for only one cell.
• Example to use LEN function:

?   

Additional Information

• Financial functions in EXCEL are FV Function, IPMT, XIRR in Excel, PMT Function, IRR Excel Function, RATE Function, NPV Function, etc.
• Logical functions in EXCEL are AND Function, NOT, OR Excel Function, TRUE Function, IFERROR Excel Function, Excel XOR Function and Excel Lo
• Math functions in EXCEL are EVEN Excel Function, SUM Function, POWER Function, SUMIF and LOG Excel Function.