Split binary numbers in different cells

cgcamal · Oct 23, 2008

Hi everyone,

I have a matrix of binary numbers, Do you know how can I split every
binary number (e. g. 00101100011) putting in different cells?

Example:

Rich (BB code):

Original-->binary number splitted
--A1--->B1-C1-D1-E1-F1-G1 
001011--0--0---1--0--1--1

Thanks in advantage

Best regards

Jonmo1 · Oct 23, 2008

Try

=MID(A1,COLUMNS($A1:A1),1)

Fill right

hkaplan2 · Oct 23, 2008

Assuming the numbers are all the same digit size, something like this:

In B1: =left(A1,1)
In C1 =MID(A1,2,1)
In D1 =MID(A1,3,1)

etc.

Tom Urtis · Oct 23, 2008

jonmo1 said:
Try

=MID(A1,COLUMNS($A1:A1),1)

Fill right

Did that really work for you when you tested it...didn't work for me but this does:

=MID($A1,COLUMN()-1,1)

Jonmo1 · Oct 23, 2008

Did that really work for you when you tested it...didn't work for me but this does:

Ah Cra#! I missed a $

=MID(A1,COLUMNS($A1:A1),1)
should be
=MID($A1,COLUMNS($A1:A1),1)

Split binary numbers in different cells

cgcamal

Active Member

Excel Facts

Jonmo1

MrExcel MVP

hkaplan2

Active Member

Tom Urtis

MrExcel MVP

Jonmo1

MrExcel MVP

Similar threads

Forum statistics

Share this page

Split binary numbers in different cells

cgcamal

Active Member

Excel Facts

Jonmo1

MrExcel MVP

hkaplan2

Active Member

Tom Urtis

MrExcel MVP

Jonmo1

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock