USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What Excel function counts the characters inside a cell?
|
|
LEN
|
|
|
AVERAGE
|
|
|
IF
|
|
|
COUNT
|
Explanation:
Detailed explanation-1: -When you need to count the characters in cells, use the LEN function-which counts letters, numbers, characters, and all spaces.
Detailed explanation-2: -To use the function, enter =LEN(cell) in the formula bar and press Enter. In these examples, cell is the cell you want to count, such as B1. To count the characters in more than one cell, enter the formula, and then copy and paste the formula to other cells.
Detailed explanation-3: -Description. LEN returns the number of characters in a text string. LENB returns the number of bytes used to represent the characters in a text string.
There is 1 question to complete.