| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically printing psted text over 250 characters to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
