SOLVED

Right function

Copper Contributor

Hi,

 

Is there a way for the right function to omit zeros from the start of the findings?

My example is: we use the last digits of our item codes to generate a batch number; the format always starts with the letter I and then has 5 numeric following the letter. I only want to capture the numbers greater than zero from the item code!

So if I had our item I01141 it would return 1141, but if I had item I00141 it would return 141 and omit the zeros. Anybody got an idea on how to do this please?

1 Reply
best response confirmed by Mark_Harding (Copper Contributor)
Solution

@Mark_Harding 

=--RIGHT(cell,5)

 

1 best response

Accepted Solutions
best response confirmed by Mark_Harding (Copper Contributor)
Solution