Proper text

Hi Carol.

I don't know of a shortcut for proper text in Excel. In Word it is Shift+F3.

Here is a way to convert text to proper text with Excel.

Suppose you have a list of words typed in lower case in cells A1:A8. To turn the text into proper case:

1. Select the adjacent blank cell and type =Proper(A1).
2. Autofill through to B8.

3. To replace the original data copy the cells B1:B8 and paste as values back to A1:A8.
4. Finally clear the range B1:B8.

Sorry not to find you a shortcut. It is possible with a macro but that probably wasn't what you saw on your Excel Intermediate course.

Regards
Doug Dunn
Best STL