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


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=565265

counting characters inside a cell
 

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

counting characters inside a cell
 

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

counting characters inside a cell
 

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

Cheers

Simon


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=565265

counting characters inside a cell
 

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

counting characters inside a cell
 

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


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=565265