How-To Geek on MSN
Don't trust Excel's COUNTA function to count non-blank cells—here's a better method
In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells.
Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. Luckily, Microsoft included a couple of useful tools for locating text parts and replacing them ...
The FIND function allows you to find a text string within another. It returns the position at which a character or string begins within another text string. The output of the above function will be 5, ...
You can add text to a cell in Microsoft Excel the traditional way by simply typing, but there are other ways to get the job done. For example, you can use a formula, or even a function to accomplish ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback