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
Printable View
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
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.
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
Why the first 2 numbers are reversed and the third one is not reversed. What is the rule?
??!!Quote:
Originally Posted by mahmoud-lee
Yes, they give you exactly the same results as on your example workbook (except for Ingolf's observation in msg#4). See attached.Quote:
Originally Posted by mahmoud-lee
Because the total number consisting of 8 digits
These two digits only
OK
Put this formula in C3
=MID($A3,11-COLUMN(),1) then drag to the right and down.
The same problem
The problem appears when the number is equal to two digits
Thank you very much
Excellent thinking
Sorry,for the effort
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))
Quote:
Originally Posted by mahmoud-lee
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.
Mister (Admin)
The formula is given (# VALUE!)
But I do not know why?
Sorry, forgot to provide the C1 formula
in C1
=max(len(a3:a10))
array formula
You did it
Thank you Mister (Admin)
You are a wonderful
Thank you for Mister (P4cal) too
Thank you all for your efforts