hi everyone,
I want to count the number of characters in the selected cell of an Excel document. Can anybody please provide the ideas with respect to this....thank you
hi everyone,
I want to count the number of characters in the selected cell of an Excel document. Can anybody please provide the ideas with respect to this....thank you
Download the tool - ASAP Utilities and install in your system. This tool helps you to tell you how many characters there are in your active cell.
For example, if the cell contains the value 'Microsoft Excel' this tool will result 15 characters.
In the Excel menu,
choose ASAP Utilities » Information » Count number of characters in selected cell
Here's the ultimate solution for you - http://support.microsoft.com/kb/187667
This link contains the following information :
The number of occurrences of a text string in a range of cells.
The number of occurrences of a character in one cell.
The number of occurrences of a character in a range of cells.
The number of words (or text strings) separated by a character in a cell.
what about this, if you want to find the number of characters in a cell A1 or say the length of cell A1, and store in a cell B1, then -
B1 = len(A1).
Very Simple (as mentioned by Sam.D) !! To find the number of characters in a cell, enter this formula in another cell.
=LEN(A1)
reduced my effort a lot..
thanks guys
You can do that by using SUBSTITUE syntax in Microsoft Excel. The exact formula for that is - =substitute(text,old_text,new_text,instance_num). You can simply test that formula and checkback. This can be used to count words in a range in Microsoft Excel. You cannot do much in that, but it works fine. I had tested this on a table and it showed up appropriate number.
Bookmarks