counting characters in a cell

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

How can I have cell B2 return the number of characters in cell B1?

Thanks.
 
Do you consider <space> as a character?

If you *don't*, this is number of characters, not counting spaces:

=LEN(SUBSTITUTE(B1," ",""))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

How can I have cell B2 return the number of characters in cell B1?

Thanks.
 
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

Cell with same number of characters 2
Eliminating cells with non-matching characters 1
how to return "summary" of all non-blank cells plus their headers 10
Square character(s) in cells 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Excel In Excel how can I block the contenent of a cell? 0
Counting Characters 1
Displaying a range based on a cell's contents 3

Back
Top