Hey
Harry,
I understand your frustration with Excel automatically changing the case of your text. Luckily, there is a simple solution to this problem.
- Select the cell or range of cells that contain the text you want to keep in its original case.
- Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
- In the "Format Cells" dialog box, click on the "Number" tab.
- In the "Category" list, select "Text".
- Click "OK" to close the dialog box.
Now, Excel will treat the text in the selected cells as text and will not change the case of the letters.