MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Brian Burns on January 31, 2002 1:11 PM


Do you know how to implement the “Proper” function throughout an entire worksheet where all the fields already have data (text) in them???

I would think I could select the entire worksheet or just each column individually and select the Proper function but it does not work - ??



Posted by anno on January 31, 2002 1:38 PM

a quick and ugly way is to go to another worksheet and in A1 enter a reference to your first worksheet with the 'proper'function eg. =PROPER(Sheet1!A1). copy down/across as needed. only thing is you'll lose any cell formatting.

Posted by Jack in the UK on January 31, 2002 1:57 PM


I trust you know what proper does? returns text to proper text ir


Jack In The UK (Proper) its used in addresses and so on, i use in every sheet, but im a finance bod / person so letter and so on are me.
all it will do is that BUT... be very careful it messes thigs about
LONDON SW9 Brixton
London Sw9 Brixton is not right, post coe go wrong
So thats it good luck.