[Bev]

I am trying to change the text in a spreadsheet. It has been typed in capitals and I want it in lower case with capitals where they should be. I have found a function called PROPER but I only seem to be able to change one line at a time if I try selecting a range of cells I get the hash value error message - also it doesn't change the line where its typed but copies it to the cell where the function is. Surely there is some easy way of converting the text of a whole worksheet - you can do this is Word. Please help. Thanks

Beverley