Extract characters

[Ivor Williams]

I have a string of numbers 28347465 in column A. I want to extract the
first, third, fifth and seventh numbers and put them into their own columns.
So 2 would be in column B, 3 would be in column C, 7 would be in column D,
and 6 would be in column E. How can I do this?

Ivor

 

[Norman Jones]

Hi Ivor,

Try:

B1 =MID(A1,1,1)
C1 =MID(A1,3,1)
D1 =MID(A1,5,1)
E1 =MID(A1,7,1)

 

[Frank Kabel]

Hi
in B1 enter
=MID($A$1,(COLUMN()-2)*2+1,1)
and copy to the right