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 leftYes, 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.

[mahmoud-lee]

Mister (Admin)
The formula is given (# VALUE!)
But I do not know why?

[Admin]

Sorry, forgot to provide the C1 formula

in C1

=max(len(a3:a10))

array formula

[mahmoud-lee]

You did it
Thank you Mister (Admin)
You are a wonderful
Thank you for Mister (P4cal) too
Thank you all for your efforts