propercase function

drcz · #1 05-08-2016, 09:57 PM

thank you.
ok, I will use # ...

now this started to give me some results.
my text: thIs TeXT has to bE transformed wITh CaPITAL LETTERS

became: this Text has to be transformed with Capital Letters

and it should be: This Text has to Be transformed With Capital Letters

This, Be and With are not having the Capital letter.

macropod · #2 05-08-2016, 10:10 PM

Quote:

Originally Posted by drcz

my text: thIs TeXT has to bE transformed wITh CaPITAL LETTERS
became: this Text has to be transformed with Capital Letters

and it should be: This Text has to Be transformed With Capital Letters

How do you expect the macro to know when a word that begins with a lower-case letter should actually start with an upper-case letter???

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
IF Function	Azleenda	Excel	2	11-10-2015 10:06 PM
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM
if function help	jim831	Excel	2	10-29-2010 07:06 PM