How to change Uppercase to lowercase in an easy way?

[nesplb]

Hi!
I'm kinda new to VB for Excel so i wonder how I easy can change uppercase text to a combination of lowercase and uppercase for an entire Excel sheet?

The pattern is like this: "SOME ADDRESS" should be: "Some Address" and so on.... Every word is supposed to start with an uppercase letter.

In advance thanks!

Sincerely

Pål, Oslo

Pål Nesteby

PDC-Tangen
Norway

 

[PHV]

As we are in the VBA forum, have a look at the StrConv function and the vbProperCase constant.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[johnwm]

You could loop through the sheet and use the VBA StrConv function on each cell - I know it's slow, but it's still quicker than typing!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[nesplb]

Exactly what I needed! Thank you very much!

Pål Nesteby

PDC-Tangen
Norway