You can use a formula in a Helper column: =UPPER(A1). Then use Edit/Copy and
Edit/Paste Special,Values to convert those formulas to their values.

Another solution is John Walkenbach's Power Utility Pack, available for
purchase at www.j-walk.com

On Sun, 10 Apr 2005 08:47:02 -0700, smithrdsr
wrote:

How to change data by column or comlete spreadsheet from lower case to upper
case by column.