Did you try the CTRL + F replace feature it will fix any of those 1500 entries with 1 click in a matter of seconds. Try this first and see if it finds the one that was missed or at least lets Excel know what you want CJ in the list to look like. One more thing for ease select the column you need to modify before doing the replace. If this still is not sufficient post the workbook for additional assistance.