Change Case of text.

Microsoft Word has a function added which will allow the case of text to be changed. This is very useful, especially when you adopt a head-down-and-type-approach, later looking up to find you had the caps lock key on, and have mixed case where you wanted words starting with a capital letter.

Unfortunately, Excel doesn't have this capability (although it will auto-correct some mistakes for you.) The Change Case macro will display a form allowing the same functionality as the MS-Word option - as shown below ;

Options available are ;