Quote:
Originally Posted by ep2002
I already fixed it 5 minutes after I made the mistake. That didn't help.
And there would be no way to search every single entry to see if one slipped by. I have 1,500 entries.
I doubt there's one earlier on in my work b/c the auto suggest always capped the C before, so I know it only started on that one mistake.
|
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.