+ Reply to Thread
Results 1 to 3 of 3

Convert Binary Weeks to Number String

  1. #1
    Registered User
    Join Date
    01-10-2017
    Location
    UK
    MS-Off Ver
    2013
    Posts
    23

    Convert Binary Weeks to Number String

    Good afternoon all.

    I think this is a simple problem. I say this because I had someone help with a similar issue before, with the solution being attached.

    My problem is that I work in timetabling, and need to export data often in a horrible format into excel.

    One of the exports involves using a "binary" coding of Weeks 1 to 52. For example, an activity taking plce from weeks 1 to 5, Week 10, and weeks 50 to 52 would be noted as 1111100001000000000000000000000000000000000000000111.

    The formula I was furnished with last time arranged for a text-to-binary sort of function, giving the above binary format from text week noting such as "1-10, 11-15"


    For this problem, I need a formula or macro that will convert the binary into individually-listed weeks. EG. 1111100001000000000000000000000000000000000000000111 would become 1,2,3,4,5,10,50,51,52

    I've attached a spreadsheet that should explain a bit more skilfully

    Many thanks all,

    Excel Washington
    Attached Files Attached Files
    Last edited by ExcelWashington; 11-20-2020 at 09:10 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Convert Binary Weeks to Number String

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-10-2017
    Location
    UK
    MS-Off Ver
    2013
    Posts
    23

    Re: Convert Binary Weeks to Number String

    Thanks Bo_Ry - this works perfectly.

    And will save me hours on hours of manual manipulation here.

    Eternally grateful

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert Hex values to Binary
    By Schiavoni in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-17-2020, 12:14 PM
  2. Convert to Binary
    By Dhelp in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-26-2016, 01:42 AM
  3. [SOLVED] Convert Binary to Octal
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-06-2015, 11:59 AM
  4. Convert Hex to Binary formula
    By EddieK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2012, 02:35 PM
  5. Convert word to binary
    By elbertvillarreal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2010, 06:09 PM
  6. Convert Binary to Hex
    By Chipmunk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-30-2009, 06:02 AM
  7. [SOLVED] Convert SpreadsheetML to binary .xls
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2006, 01:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1