I have some rather large spreedsheets that are all in upper case letters, but need to convert them to proper name format, i.e. FRED ROGERS becomes Fred Rogers. I have spent a couple of hours trying to find this. So in order to save a poor PC's life, could someone share this knowledge with me? Sorry about the OT thing.