THAT's the information I needed.
(this may be a dbl-post....my computer did something "funny" the first
attempt)
Your edits were correct EXCEPT for changing $A$1 to $E$2
Here's why:
In my original formula
=RIGHT(A1,LEN(A1)+1-MATCH(FALSE,INDEX(MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1)="0",0),0))
This part: $A$1:INDEX($A:$A,LEN(A1),1)
creates an array of cells, beginning with $A$1 and continuing down Col_A for
the number of characters in the referenced cell.
For instance, if A1 contains "abcd"....the length is 4...
so the constructed array is:
A1:A4
That constructed array is wrapped in the ROW function, which returns the row
number of the reference.
Still using my example, ROW(A1:A4) returns {1,2,3,4}
That array is used by the overall formula to pick individual characters from
"abcd"
Anyway....
all of the above is the LONG way of saying that your formula referencing
cell E2 should be:
=RIGHT(E2,LEN(E2)+1-MATCH(FALSE,INDEX(MID(E2,ROW($A$1:INDEX($A:$A,LEN(E2),1)),1)="0",0),0))
Does that help?
***********
Regards,
Ron
XL2003, WinXP