Separate reference in 2 columns.

[serge]

Hi,
I have this reference table in A1:B4 which is 0 = 00, 1 = 01, 2 = 10, 3 = 11
I would like to separate them in 2 columns, what formula should be in column B7 and C7 ?
Thank you.

 

[etaf]

are you still using excel 2007 ?

I suspect as text
in B7
=left(B1,1) and copy down
in C7
=right(B1,1)

 

[serge]

Thank you etaf, but I may not explain myself right, I need the formulas to take the starting data in column A7 going down.

 

[etaf]

so you want to lookup A7 from the range A1 to A4 , and then find the corresponding value in B1 to B4 and split
as asked

are you still using excel 2007 ?

 

[serge]

Yes, but I don't know how to create the formula with a leading 0.

 

[Peter_SSs]

It is unclear whether the values in B1:B4 are Text or Numbers formatted to show 2 digits.

If Text this

25 01 15.xlsm
	A	B	C
1	0	00
2	1	01
3	2	10
4	3	11
5
6
7	0	0	0
8	1	0	1
9	2	1	0
10	3	1	1
serge

Cell Formulas
Range	Formula
B7:B10	B7	=LEFT(VLOOKUP(A7,A$1:B$4,2,0),1)
C7:C10	C7	=RIGHT(VLOOKUP(A7,A$1:B$4,2,0),1)

If Numbers

25 01 15.xlsm
	A	B	C
1	0	00
2	1	01
3	2	10
4	3	11
5
6
7	0	0	0
8	1	0	1
9	2	1	0
10	3	1	1
serge (2)

Cell Formulas
Range	Formula
B7:B10	B7	=LEFT(TEXT(VLOOKUP(A7,A$1:B$4,2,0),"00"),1)
C7:C10	C7	=RIGHT(TEXT(VLOOKUP(A7,A$1:B$4,2,0),"00"),1)

 

[serge]

Yes still on 2007

 

[serge]

Thank you Peter, that works perfect for me, well appreciate it.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.