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
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
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
Bookmarks