How do I use "Proper worksheet functions" to an existing datatba

[STEVE665]

I am trying to change the whole document from Upper case to Proper case, but
it don't seem to be accepting my formula. What am I doing wrong?
And I am also trying to change the whole document in one go....

 

[Frank Kabel]

Hi
you have to enter this formula in a separate cell. If you want to
change the values in place you'll need VBA. see:
http://www.cpearson.com/excel/case.htm

 

[Govind]

Hi,

The proper worksheet function changes the formula only in the proper
format, which is first letters in uppercase and the rest in small case.

To change everything to uppercase, you should use =UPPER() function.

Regards

Govind.