A pallet register contains PL05 from one import and PL05 from another. They look similar, but the first uses full-width characters. Build a narrow helper key before checking whether the records match.

Keep the original and convert beside it

Put the two codes in A2 and A3 as text. In a spreadsheet editor that supports ASC, enter =ASC(A2) in B2 and fill down. With support for these characters, both helper cells should read PL05. Check that the zero in the code is still there.

The example compares full-width PL05 and narrow PL05 in the source column.

Example inputs. Preserve the original codes in their own column.

Inspect the collision before using the key

Filter the helper for PL05 and compare both source rows with the pallet registry. If they represent the same pallet, decide which record to keep for the task. If they represent different pallets, the helper alone cannot distinguish them.

Both source rows map to PL05 in the helper, prompting a duplicate-key check.

Example matching check. Confirm whether the two rows represent the same pallet.

Test representative input in the spreadsheet editor that will receive the workbook. Width conversion handles character width for supported inputs. The registry determines whether the resulting code is valid.

Microsoft’s ASC reference.