Actually, my part numbers all have one (1) leading zero.
Example: 091-0002, 098-1003
There are three (3) places, a hyphen (-) and from four (4) places and
sometimes another hyphen (-) and two to three more numbers
Example: 098-1812-01
The way the file was sent, there were too many leading zeros.
Example: 0091-0002, 0098-1003. etc.
There are over 10,000 entries--too many to deal with individually. I need a
quick and easy way to make the corrections.
Sharon

"Fredrik Wahlgren" wrote:


"sharonkturner" wrote in message
...
I have a rather large (thousands) db of part numbers that have an extra
leading zero. Is there a simple way to make the correction?

Assuming that your part number is in column A, you can use a formula like
this in another column, say D
=RIGHT(A1,LEN(A1)-1)

However, if not all part numbers have a leading zero, use this instead

=IF("0" =LEFT(A1,1),RIGHT(A1,LEN(A1)-1),A1)

Drag the function downwards. Having don that, select all the values in
Column D and then copy them. Now select the A column and then do a Paste
Special... Select the "Values" radio button and hit OK. I have the Swedish
version of Excel, I hope my translation is OK. As always, use a copy of your
original workbook when you do a major change.

Best Regards,
Fredrik