Assuming the data is in sheet1, put a formula like =upper(sheet1!a1) in a1 of sheet2. Copy (drag and drop the copy handle is the easiest way) all over (all the cells with serial number). Then edit>copy>paste special>values back to sheet1. You can delete sheet2 afterwards.

Hope this helps.


Kees