Makakuha ng detalyadong mga sagot sa lahat ng iyong tanong sa IDNStudy.com. Sumali sa aming platform ng tanong at sagot upang makakuha ng eksaktong tugon sa lahat ng iyong mahahalagang tanong.

What is the formula in MS Excel if you want to find the number of the characters on the cell: R3 Write the correct formula. *​

Sagot :

Answer:

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

Explanation:

To test if a cell (or any text string) contains a number, you can use the FIND function together with the COUNT function. In the generic form of the formula (above), A1 represents the cell you are testing. The numbers to be checked (numbers between 0-9) are supplied as an array.