|
Subject:
|
first character as Upper Case
|
|
Posted By:
|
crmpicco
|
Post Date:
|
5/17/2005 4:18:14 AM
|
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
|
|
Reply By:
|
PedroZorro
|
Reply Date:
|
5/30/2005 1:14:30 PM
|
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.
|
|
Reply By:
|
BrianWren
|
Reply Date:
|
5/31/2005 12:29:58 PM
|
Hey Pedro: What is the point of your posting? If you don't have something to add, you shouldn't add something...
|
|
Reply By:
|
marcostraf
|
Reply Date:
|
5/31/2005 3:42:01 PM
|
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
|
|
Reply By:
|
vb certified
|
Reply Date:
|
7/1/2005 1:35:51 PM
|
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.
|
