Extract characters

I

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
 
N

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)
 
Top