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