Q&A

# Post History

60%
+1 −0
#4: Post undeleted by Alexei‭ · 2021-05-26T18:07:47Z (2 months ago)
#3: Post deleted by pnuts‭ · 2020-12-21T23:44:21Z (7 months ago)
#2: Post edited by pnuts‭ · 2020-09-05T16:15:09Z (11 months ago)
• 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 by pnuts‭ · 2020-09-05T16:13:16Z (11 months ago)
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.