Today I was working on a huge Microsoft Excel spreadsheet that contained a column of law firm names. Most of these names were in all caps, instead of only capitalizing the first letter of each word and leaving the rest lowercase. I wanted them properly capitalized, so I struck out to find an easy way to do it.
Proper() to the rescue! Simply put, proper() converts text to its proper capitalization. All I had to do was something like “=proper(a1)” and the firm’s name was automatically converted to only having the first letter of each word capitalized. The only problem is that if A1 contains something that you want to keep all caps (such as PC, LLP, or III for a person’s name). The simple solution here is to use the proper() function and then do a quick search & replace for those values that should remain all caps.
In the end, proper() allowed me to convert 140+ firm names to proper capitalization in about a 30 seconds, instead of the 15 minutes it would have taken by manually re-typing them all. That’s a time saver, right?
[tags]legal andrew, microsoft excel, excel, proper, capitalization, caps[/tags]
Get more legal tips