How can i make every word inside a cell have its first character as Upper Case?

e.g.
BD Add-ons rules

changes to

BD Add-ons Rules

TIA>

Picco

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

If you are not new at programming, and you think about it for a while you will find out the answer. It is very simple problem.

Greeting, Pedro.

Hey Pedro: What is the point of your posting? If you don't have something to add, you shouldn't add something...

Hi Brian,
this is what Mr.Zorro wrote in another thread:

"PD.: If you don´t know the answer, please do not type nonsense."

isn't that lovely?

To cmrpicco:

which "cell" are you refering to? Take a look at the StrConv function (used with the vbProperCase setting) and see if that helps

Marco

the guy that says you should post somthing useful doesnt even pst somthing useful LOL! But yes marcostraf's way would be the way to go i belive.
E.X.
    Dim str as string
    str = "BLAH"
    str = StrConv(str,vbpropercase)

hope that helps you are even still wondering :)

~~~~~~~~~~~~~~~~~~~~~
I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter.