The reviewer needs a suffix to recognize a record. Create a display column for that purpose and keep the full ID in the working file.

Mask the prefix and handle short IDs explicitly

Put fictional ID AB001429 in A2 as text and enter in B2:

=IF(A2="","",IF(LEN(A2)<=4,REPT("*",LEN(A2)),REPT("*",LEN(A2)-4)&RIGHT(A2,4)))

The result is ****1429. This rule fully masks 0123 and any other ID of four characters or fewer. A blank stays blank.

The display column replaces the first four characters of AB001429 and keeps the suffix 1429.

Illustrated masking formula. Store the original as text to preserve any leading zeros.

Build the delivery from values only

Copy the display column and use Paste Values in a fresh workbook. Add only the other fields the reader should receive. Open the delivery file and check that it has neither the raw IDs nor formulas referring to them. Check for suffix collisions if readers need to distinguish records.

A short ID is fully masked and the delivery file contains only the copied display value.

Illustrated handoff check. Inspect the new file for the raw column and formulas before sharing.

Ulet steps for pasting formula results as values

Microsoft’s REPT function reference