Hi Guys,

Hopefully someone can help me out with this one please, I have looked through the forum but can't find a relative thread to my question


I have a sheet covering various ranges A3 down to A37 through to E3 - E37

All these cells contain text

What I would like to do is automaically change any entries made in the cells to Proper case.

Is there anyway of doing this? I have tried the PROPER case function but this does not work for what I need.

Many thanks

Paul