PDA

View Full Version : [SOLVED:] Proper case question


Dreamer
06-28-2005, 08:44 PM
When I use the Proper function in excel,
the text after (') becomes upper case..
e.g I don'T Know

How can I write a macro so that it can become ... " I don't know " ?

Thanks in Advance.
Jacob Hilderbrand
06-28-2005, 09:15 PM
Do you just want to capitalize the first letter in the cell?


=UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)
sheeeng
06-28-2005, 09:58 PM
Do you just want to capitalize the first letter in the cell?

=UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)

Hi DRJ, and Dreamer (http://www.vbaexpress.com/forum/member.php?u=2552), :hi:

DRJ, I think Dreamer is saying that he wants to make the character after ' is lower case.

=PROPER("i don't know")

will output

I Don'T Know. (But Dreamer needs "I Don't Know")

HTH :hi: :friends:
sheeeng
06-28-2005, 10:12 PM
It seems that =PROPER(some string) cannot work to produce what Dreamer needs.

Later I found out this macro which might be helpful.


StrConv("i don't know", vbProperCase)

It can output -> I Don't Know.

HTH :friends:
Dreamer
06-29-2005, 08:32 PM
THANKS!:)
sheeeng
06-29-2005, 09:33 PM
THANKS!:)

Welcome to VBAX.

You're welcome.

Hope that this forum can help u. :friends: