Separating Digits from whole number.

[serge]

Hi,


I'm looking for a formula that will separate the digits from a whole number, into single cells.


In cell AM6 I have the number : 5780 then I need starting in cell ; AO6, 5, AP6, 7. etc...


Numbers are from 1 digti to 5 Digits long.


Thank you.
Serge.

 

[shaowu459]

=IF(COLUMN(A1)>LEN($AM6),"",RIGHT(LEFT($AM6,COLUMN(A1))))

copy formula to the right four cells.

 

[jtakw]

Hi,

Use AO6 formula if you want results converted to Real Numbers for further comparison/math.
Use AO8 formula if you Only want the digits extracted, results remain as Text.

Either way, formula copied across as far as needed:

Book1
	AM	AN	AO	AP	AQ	AR	AS	AT	AU
6	5780		5	7	8	0
7	5780123		5	7	8	0	1	2	3
8	5780		5	7	8	0
9	5780123		5	7	8	0	1	2	3
Sheet104

Cell Formulas
Range	Formula
AO6	=IFERROR(MID($AM6,COLUMNS($AO6:AO6),1)+0,"")
AO8	=MID($AM8,COLUMNS($AO8:AO8),1)

 

[serge]

shaowu and jtakw,

Thank you to both of you, your formulas work great, Really appreciate the help.
Serge.