counting characters inside a cell

[simonsmith]

Hi,
Is there any way of counting the number of characters within a cell
without having to do the text to columns thing?

I have many screen captures of TRAU frames and need to quickly
determine the number of bits in the string e.g. this could be in a
single cell

1111 11111111 11111111 11111111 11111111 11111111 11111111
11111111


Thanks in advance


Simon

 

[J.Evans.1970]

Try the LEN() function.

=LEN(B2)

 

[Guest]

Simon,

=LEN(SUBSTITUTE(A1," ",""))

Assuming the blanks are the "delimeters" btewwen your bit strings

 

[simonsmith]

Thanks, I think that will work, just need to strip off the gaps

Cheers

Simon

 

[Guest]

...btewwen!? ...between!

I assumed you did want count of 1s only; otherwise LEN(A1) will give total
length including blanks..

 

[simonsmith]

So I when use LEN(SUBSTITUTE(A3," ","")) that works just fine!