find: . (or whatever)
To get just the FIRST 3 characters of a cell :
To get everything AFTER the first 3 characters of a cell :
To get the LAST 3 Charcters
The steps :
REMOVE DUPLICATES FROM A COLUMN IN EXCEL
Select the range of cells that has duplicate values you want to remove.
Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.