Use the macro from here

http://www.mvps.org/dmcritchie/excel/proper.htm#proper



Regards,

Peo Sjoblom

"Danielle via OfficeKB.com" <u14899@uwe wrote in message
news:55d79d571407c@uwe...
I need to apply the PROPER function to an entire worksheet that has a few
thousand cell entries. I have two problems in accomplishing this:
First, I can't format more than one column- and I'm only able to that
using
the fill-handle. For some reason, trying to do this as a traditional
function like this: =proper(cell:cell), is not working.
Second, I end up with two sets of data- one formatted and one not. I need
the function to be 'underneath' the data.
Is there a way to write one function for the entire worksheet, and have it
applied to the entire worksheet and not as a new set of data?

Appreciate any help,

Danielle