Convert Excel Case - Upper Case, Lower Case, Proper Case

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact | Forum

Convert Excel Case - Upper Case, Lower Case, Proper Case

Select a range of cells, invoke 'Selected Area->Convert->Text Case to->...', you can convert text cases to proper case, upper case, or lower case.

Practice file - convert-case-demo.xls (16k)

Converted to proper case (upper case on the first letter in each word, lower case the rest)

Convert Upper, Lower, Proper Case

Converted to lower case:

Convert Upper, Lower, Proper Case

You can also select a single cell in a table's column, invoke 'Column->Convert->Text Case to->...', this will convert the entire column's text cases to proper case, upper case, or lower case, and the converted values will be placed in a newly inserted column next to the original column.

Converted to proper case (upper case on the first letter in each word, lower case the rest)

Convert Upper, Lower, Proper Case

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.