I am trying to take out "00" from RIGHT side and cant think of any formulas. Please help.
Original Data
10210000
10360000
11002025
With this Formula it works : =IF(RIGHT(E2,4)="0000",LEFT(E2,LEN(E2)-4),E2)
Results:
1021
1036
11002025
However, when my data starts with Letter and zeroes from the beginning such as:
00A0660000 formula above give me "00A066", so how to keep the above formula and also have this one as of "A066".
Will really appreciate your help on that.
Thank you so much
Bookmarks