Thanks for the suggestion, Mike. I tried the substitute nothing for the code160 formula, but it didn't remove the spaces. After entering the code in a blank column, and copying it down the column, (the part numbers in the cell containing the formula matched the corresponding part # in column A), I copied only the values over the original part number. I re-ran the pivot table, with the same results. If I check the part numbers in column A, (AFTER pasting the values over them), they still show a blank at the end of the part number.

Any other suggestions?

Thanks in advance.

Hutch