Hi there,

I have a worksheet I have a right function which looks up the last 5 digits
in a cell. These digits represent the inventory code for individual inventory
items.

My problem is that sometimes these inventory codes are 6 digits long and
sometimes they are 5.

I can look up the last 6 digits and get a 0 infront of the 5 digit codes,
but I want to compare the data to data from another computer program which
won't work if the codes aren't represented in the same way. Can anyone think
of a way to look up the last 5 or 6 digits? Could this be done with an IF
combined with a RIGHT?

Cheers,

Sue