Cut the Code Off the Front of Every ID in Excel (RIGHT)

Description:
Filmed in Excel for the web, which is free in a browser.

An imported list whose IDs all carry the same warehouse prefix at the front cannot be matched against anything until the prefix comes off. This formula cuts a fixed number of characters off the front of every ID in a new column, and the original column is never edited.

Steps:
1. Click the first cell of the empty column beside your IDs.
2. Type =IFERROR(RIGHT(A2,LEN(A2)-3),A2) where A2 is the first imported ID, and press Enter.
3. Drag the small square in the corner of the cell down to fill the formula for every row.

How it reads: RIGHT keeps characters counted from the right end. LEN counts the whole ID, so the length minus three keeps everything except the first three characters. The 3 is the length of the prefix on this list: count your own prefix and use its length instead.

Why the IFERROR guard: one imported row here is shorter than the prefix itself, so its count goes negative and the plain formula errors on it. IFERROR hands the original cell back for that row, so a broken import line passes through instead of poisoning the column.

The best thanks is a subscribe.