Extracting numbers from a string

[Zac]

Take 123456789
I want to extract each number into 9 consecutive cells.
1 will be in A1,
2 will end up in B1,
etc.

How can I accomplish this. I've tried different
things using the RIGHT function, but I'm stuck.

Need your help,
Thanks,
Zac

 

[Aladin Akyurek]

Zac,

Lets say that the target number is in A1.

In B1 enter:

=MID($A$1,COLUMN()-1,1)

and copy across as far as needed.

Or use Data|Text to Columns, where you choose 'Fixed Width' and bring break lines between each digit by clicking at desired locations.

Aladin

 

[Zac]

I'll try it later on, thanks.
Have a meeting from 8:00 till 4:00 today.