Thank you, Computer Geeks

Just learned this while working on a large mail merge, all of which was originally typed in CAPS.

I tried formatting the font but it wasn't working. This formula worked like a charm, and now my letters don't look like this.

Dear MARGARET,

Thanks to those computer geeks who post these kind of tips on their blogs!

Change the Case of Text in Cells in Microsoft Excel

There are several methods for doing this; we'll provide them all.

Using Formulas

Our formulas assume you have your data beginning in Cell A1 and you'll copy down. This is the easiest way for people who need to do it quickly and seldom.