deconcatenate A1 number to B1, C1,D1....

[jake]

Say I have a number e.g. 8746 in cell A1. I want to put that number into the
adjacent cells as such

A1 B1 C1 D1 E1
8746 8 7 4 6
8747 8 7 4 7
8748 8 7 4 8

 

[macropod]

Hi Jake,

Use the Text-to-Columns toolbar, setting fixed widths equal to one
digit/cell.

Cheers

 

[Biff]

Hi Jake,

You will need a seperate formula for each digit:

B1 =LEFT(A1,1)
C1 =MID(A1,2,1)
D1 =MID(A1,3,1)
E1 =RIGHT(A1,1)

The above functions are *TEXT* functions and the returned
values are *TEXT* even though they're numbers. If you need
to do calculations on the parsed digits you can have the
returned values remain numeric numbers by using either of
two methods.

=--LEFT(A1,1)

=VALUE(LEFT(A1,1))

Biff