counting characters inside a cell

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

Try the LEN() function.

=LEN(B2)


simonsmith wrote:
> 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
>
>
> --
> simonsmith
> ------------------------------------------------------------------------
> simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
> View this thread: http://www.excelforum.com/showthread...hreadid=565265

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

Cheers

Simon

Simon,

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

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

"simonsmith" wrote:

>
> 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
>
>
> --
> simonsmith
> ------------------------------------------------------------------------
> simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
> View this thread: http://www.excelforum.com/showthread...hreadid=565265
>
>

...btewwen!? ...between!

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

"Toppers" wrote:

> Simon,
>
> =LEN(SUBSTITUTE(A1," ",""))
>
> Assuming the blanks are the "delimeters" btewwen your bit strings
>
> "simonsmith" wrote:
>
> >
> > 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
> >
> >
> > --
> > simonsmith
> > ------------------------------------------------------------------------
> > simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
> > View this thread: http://www.excelforum.com/showthread...hreadid=565265
> >
> >

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