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???

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