Split binary numbers in different cells

[cgcamal]

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:

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

Thanks in advantage

Best regards

 

[Jonmo1]

Try

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

Fill right

 

[hkaplan2]

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]

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]

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)