You would enter the formula where you want the results to appear. If, for
instance, you want to change all of column A from uppercase to proper, insert
a column before column B. In B1 enter =proper(A1). Copy that formula down
through column A. Then copy/paste special values. Finally, delete column A
if you don't want to keep it around.

"Colleen Little" wrote:

I have a spreadsheet with data containing UPPERCASE. I need to use the
PROPER formual and do not know where to enter this formula on the spreadsheet.