Capitalizing the first word of a sentence in Excel

Dumb me. I spent 15 minutes looking around online today for a way to do this and didn’t find much – a few macros that scared me and not much else.

In Excel (2003) there are three formulas that let you change the case of a piece of text – PROPER that capitalizes the first letter of every word; UPPER that capitalizes every letter; and LOWER that (surprise!) makes every letter lowercase.

Note that Microsoft helpfully did not include an option for sentence case in Excel 2003.

But they did include it in Word… hmmm. SENTENCE capitalizes only the first letter of every string. I had a whole column I needed to change, so I copied it to Word, applied sentence case text formatting to it, and copied it back to Excel.

I can’t believe I didn’t think of that first. Hopefully this will save someone else some time surfing for an answer.


Leave a Reply

Your email address will not be published. Required fields are marked *