DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
TRUE
|
|
|
FALSE
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The function counts letters, numbers, characters, and all spaces. For example, the length of “It’s 98 degrees today, so I’ll go swimming” (excluding the quotes) is 42 characters-31 letters, 2 numbers, 8 spaces, a comma, and 2 apostrophes. To use the function, enter =LEN(cell) in the formula bar and press Enter.
Detailed explanation-2: -When you need to count the characters in cells, use the LEN function-which counts letters, numbers, characters, and all spaces.
Detailed explanation-3: -The Microsoft Excel SPACE function returns a string with a specified number of spaces. The SPACE function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel.
Detailed explanation-4: -Count number of characters excluding spaces with formula Select a cell which will output the counted result, for instance, C1, and type this formula =LEN(SUBSTITUTE(A1, ” “, "")), and press Enter key to get the result.