No. separation

[mahmoud-lee]

I want to separate the number in the model, such as Shit
From right to left
I wish the solution by the formula
I am using Office 2003

[p45cal]

Spreadsheet Formulas
Cell Formula
C3 =MID($A3,8,1)
D3 =MID($A3,7,1)
E3 =MID($A3,6,1)
F3 =MID($A3,5,1)
G3 =MID($A3,4,1)
H3 =MID($A3,3,1)
I3 =MID($A3,2,1)
J3 =MID($A3,1,1)

then copy/drag down.

[mahmoud-lee]

Unfortunately, this is not required
This version of Genius (Mr. Rick Rothstein)
=SUBSTITUTE(MID(TRIM($A$3);COLUMNS($B10:B10);1);" ";" ")
But I want this formula divides the numbers from right to left

[Ingolf]

Why the first 2 numbers are reversed and the third one is not reversed. What is the rule?

[p45cal]

Unfortunately, this is not required

??!!

But I want this formula divides the numbers from right to left

Yes, they give you exactly the same results as on your example workbook (except for Ingolf's observation in msg#4). See attached.

[mahmoud-lee]

Because the total number consisting of 8 digits
These two digits only

[Ingolf]

OK

Put this formula in C3

=MID($A3,11-COLUMN(),1) then drag to the right and down.

[mahmoud-lee]

The same problem
The problem appears when the number is equal to two digits
Thank you very much
Excellent thinking
Sorry,for the effort

[Admin]

Hi

In C3 and copied down & across,

=IF(LEN($A3)=2,MID(REPT("-",$C$1-LEN($A3))&$A3,COLUMNS($C3:C3),1),MID($A3&REPT("-",$C$1-LEN($A3)),$C$1-COLUMNS($C3:C3)+1,1))

[Ingolf]

The same problem
The problem appears when the number is equal to two digits
Thank you very much
Excellent thinking
Sorry,for the effort

I do not know what you want ...

@Admin
In your formula this part REPT("-",$C$1-LEN($A3)) will be always #value cause this $C$1-LEN($A3) will be a negative number.