Pls help me to solve this problem...
Try these
in A2
=IF(ISERR(MID(A1,LEN(A1)-6,1)),"",MID(A1,LEN(A1)-6,1))
in B2
=IF(ISERR(MID(A1,LEN(A1)-5,1)),"",MID(A1,LEN(A1)-5,1))
in C2
=IF(ISERR(MID(A1,LEN(A1)-4,1)),"",MID(A1,LEN(A1)-4,1))
in D2
=IF(ISERR(MID(A1,LEN(A1)-3,1)),"",MID(A1,LEN(A1)-3,1))
in E2
=IF(ISERR(MID(A1,LEN(A1)-2,1)),"",MID(A1,LEN(A1)-2,1))
in F2
=IF(ISERR(MID(A1,LEN(A1)-1,1)),"",MID(A1,LEN(A1)-1,1))
and in G2
=IF(ISERR(RIGHT(A1,1)),"",RIGHT(A1,1))
Hope that helps.
"Bradley" wrote:
Hi Bob,
Thanks alot for your formula and it's really interesting.
I like the way MID returns blank when beyond the string.
according to your formula, it'll be like this;
|3|6|7|8|4|9|8|
|4|5|9|4|6|2|-|
|6|3|8|1|9|-|-|
But what i trying to show is;
|3|6|7|8|4|9|8|
|-|4|5|9|4|6|2|
|-|-|6|3|8|1|9|
I want those amount to be in lineup from right to left one, hundred,
thousand,..etc..
Do u have any idea for that?
Thanks again.
Tom
"Bob Phillips" wrote:
This works for me copied across because MID returns blank when beyond the
string
=MID($A1,COLUMN(A1),1)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Bradley" wrote in message
...
my problem is that i want to copy(link) single character into multicell
from
a string.
from single cell -- 3678498 (in A1)
to these multicell -- | 3 | 6 | 7 | 8 | 4 | 9 | 8 |(A2, B2, C2, D2, E2,
F2
& G2)
When i tried to use "=MID(A1,1,1)" for (3) in 1st cell (A2),
"=MID(A1,2,1)"
for (6) in 2nd cell (B2) etc..., it's ok for 7 digits.
But it's a problem, when i tried to input 6 digits.
The formular lookup from left to right of the string.
So.. any other way to use the formular starting from right to left?
Or ???
Thanks
Tom
|