Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to count number of characters in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 05-06-2009
Member
 
Join Date: Feb 2009
Posts: 34
How to count number of characters in Excel
  

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

Reply With Quote
  #2  
Old 05-06-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: How to count number of characters in Excel

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
Reply With Quote
  #3  
Old 05-06-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: How to count number of characters in Excel

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.
Reply With Quote
  #4  
Old 05-06-2009
Member
 
Join Date: Jan 2008
Posts: 3,749
Re: How to count number of characters in Excel

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).
Reply With Quote
  #5  
Old 05-06-2009
Member
 
Join Date: May 2008
Posts: 3,312
Re: How to count number of characters in Excel

Very Simple (as mentioned by Sam.D) !! To find the number of characters in a cell, enter this formula in another cell.

=LEN(A1)
Reply With Quote
  #6  
Old 21-09-2011
Member
 
Join Date: Sep 2011
Posts: 1
ThumbsUp Re: How to count number of characters in Excel

reduced my effort a lot..
thanks guys
Reply With Quote
  #7  
Old 15-05-2012
Member
 
Join Date: Jul 2011
Posts: 618
Re: How to count number of characters in Excel

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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to count number of characters in Excel"
Thread Thread Starter Forum Replies Last Post
JavaScript to count number of images Juan-Carlos Software Development 5 11-12-2009 04:22 AM
PHP - Count number of words GlassFish Software Development 3 27-11-2009 12:19 PM
Count the number of times yes appears in a range in excel Andy Candy Windows Software 3 17-08-2009 12:33 PM
How to count number of text occurences in Excel column Anas Windows Software 3 09-06-2009 05:01 PM
How To Count The Number Of Characters? Harsh01 Software Development 2 13-02-2009 11:25 AM


All times are GMT +5.5. The time now is 03:28 PM.