IDNStudy.com, ang iyong mapagkakatiwalaang mapagkukunan para sa eksaktong at maaasahang mga sagot. Magtanong ng anumang bagay at makatanggap ng kumpleto at eksaktong sagot mula sa aming komunidad ng mga propesyonal.

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.