I had someone ask if there was an easy way to format a list with proper case- there is.

Simply use this formula: =proper(a1) for proper. You can also use =upper(a1) and =lower(a1) as well.

Jared Hawk teaches Excel Training Classes and Seminars in Boise, ID.