Proper case question

[Dreamer]

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]

Do you just want to capitalize the first letter in the cell?

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

[sheeeng]

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,

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

[sheeeng]

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

[Dreamer]

THANKS!

[sheeeng]

THANKS!

Welcome to VBAX.

You're welcome.

Hope that this forum can help u.