Only by using a macro

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


--

Regards,

Peo Sjoblom


"MISTY66" wrote in message
...
How do I add the PROPER function to an entire spreadsheet? Can it be done
all at once after the spreadsheet exists?