Search a last digit e.g 0 and trim to give rest

[excel_learner]

I am looking for a formula which searches last digit, 0 in this case, and separates the the number after 0 in next cell as below







Number
Required


1000000092
92


1000000183
183


1000001184
1184


1000021184
21184






kindly assist

[Admin]

Hi,

try

=--MID(A2,MATCH(2,INDEX(1/(--MID(A2,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A2))),1)=0), 0,0))+1,255)

[excel_learner]

Thanks, but i think i did not realise there are zeros in the rest of the numbers as well for which the above formula gives error, sorry for that...





1000000820
#VALUE!


1000001730
#VALUE!


1000002640
#VALUE!


1000002640
#VALUE!


1000000820
#VALUE!


1000001730
#VALUE!


1000003550
#VALUE!


1000000820
#VALUE!


1000001730
#VALUE!


1000002640
#VALUE!


1000004460
#VALUE!


1000005370
#VALUE!


1000006280
#VALUE!


1000005370
#VALUE!

[Admin]

Hi

If the format is like 10000##### then

=--MID(A2,5,255)

would suffice.

[excel_learner]

this works ok, thanks