On 2002-05-20 13:08, Yadlik wrote:
Can I apply proper to an entire worksheet? Or do I have to put it in each cell?
I believe you want to use the PROPER function.
If A1 contains "This is a test" then PROPER(A1) will return "This Is A Test"
Try something like this:
=SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","Q")),"q","'")