Hi Guy,

I understand your frustration with losing the leading zeros when using the FIND/REPLACE command in Excel. This is a common issue that many users face when working with part numbers or other alphanumeric data.

One solution to this problem is to use a formula instead of the FIND/REPLACE command. Here's how you can do it:

1. Insert a new column next to the column with the part numbers.
2. In the first cell of the new column, enter the following formula:
   Formula:

   =TEXT(A1,"000000000000000") 

   This formula will convert the part number to text format and add leading zeros to ensure that all part numbers have the same number of digits.
3. Copy the formula down to all the cells in the new column.
4. Select the entire new column and copy it.
5. Right-click on the original column with the part numbers and select "Paste Special".
6. In the "Paste Special" dialog box, select "Values" and click "OK".
   This will replace the original part numbers with the new formatted part numbers, including the leading zeros.

I hope this solution works for you. Let me know if you have any other questions or concerns.

Best regards,
[Your Name]