Hi!

What type of characters make up the entire string of
inventory codes?

Can you post a good representative sample (several) of
what these codes look like?

Biff

-----Original Message-----
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
.