# Post History

##
**#4: Post undeleted**

##
**#3: Post deleted**

##
**#2: Post edited**

- I believe the answer at the moment is "No" but a very simple formula in LibreOffice 5.4.3.2 can achieve the desired result:
- =LEN(SUBSTITUTE(B1;0;""))
- where B1 contains:
- =BASE(A1;2;8)
- as valid and A1 contains the number in decimal.
- The B1 cell would not be required with this version:
- =LEN(SUBSTITUTE(BASE(A1;2;8);0;""))
- This converts to binary, strips out the `0`s and counts the number of characters left thereafter.
~~With the appropriate delimiter, should also work in Excel, Sheets and OpenOffice Calc.~~

- I believe the answer at the moment is "No" but a very simple formula in LibreOffice 5.4.3.2 can achieve the desired result:
- =LEN(SUBSTITUTE(B1;0;""))
- where B1 contains:
- =BASE(A1;2;8)
- as valid and A1 contains the number in decimal.
- The B1 cell would not be required with this version:
- =LEN(SUBSTITUTE(BASE(A1;2;8);0;""))
- This converts to binary, strips out the `0`s and counts the number of characters left thereafter.
- With the appropriate delimiter, should also work
**at least**in Excel, Sheets and OpenOffice Calc.

##
**#1: Initial revision**

=LEN(SUBSTITUTE(B1;0;""))

where B1 contains:

=BASE(A1;2;8)

as valid and A1 contains the number in decimal.

The B1 cell would not be required with this version:

=LEN(SUBSTITUTE(BASE(A1;2;8);0;""))

This converts to binary, strips out the `0`s and counts the number of characters left thereafter.

With the appropriate delimiter, should also work in Excel, Sheets and OpenOffice Calc.