character count

  • Thread starter Thread starter supernova
  • Start date Start date
S

supernova

Hi,

Is there a function which will count the character in a cell?
Thanks.
 
=LEN(A1) gives the number of characters in A1

=LEN(A1)-LEN(SUBSTITUTE(A1,"A","")) counts the incidents of a particular
string in A1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Character Count 2
Cell with same number of characters 2
About references 1
Count Dates? 5
Help Needed With Count 2
SUM / COUNT formula 3
Count If Cell Value Starts with... 4
Autocopy the first cell with more than 30 characters to a different sheet? 1

Back
Top