Forcing uppercase, proper case

Giganews Newsgroups
Subject: Forcing uppercase, proper case
Posted by:  Peter Bishop (AlphamodeCompute…
Date: Tue, 21 Oct 2003

Does anyone know how to format all the cells in a column
to convert everything to UPPER CASE or Proper Case,
regardless of how text is entered?

I've set up a spreadsheet for storing names and
addresses.  I want to be able to type in lower case and
have the names converted to proper case ("John Doe") and
suburbs converted to upper case "(WAIKIKI") without having
to mess around with the Shift or Caps Lock keys.