Formula Result in lower case, First letter Cap

=LEFT(C3109,14)

How do I rewrite this formula to result in the first char being capitalized and the rest lower case?
RWayneHAsked:
Who is Participating?
 
Naresh PatelTraderCommented:
=PROPER(LEFT(C3109,14))
0
 
nutschCommented:
This will work, but PROPER is much cleaner and faster:

=upper(LEFT(C3109,1)) & lower(mid(C3109,2,13))
0
 
Rory ArchibaldCommented:
It depends what's in C3109. If the first 14 characters is two words, PROPER won't work. ;)
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Naresh PatelTraderCommented:
????
0
 
Rory ArchibaldCommented:
the first char being capitalized and the rest lower case

That's not necessarily the same as Proper Case (it's what Word would call Sentence case):

"Two words"
rather than:
"Two Words"
0
 
Naresh PatelTraderCommented:
As author dint specify any thing about it, but will you pls tell me How to over come this - just for knowledge.


Thanks
0
 
nutschCommented:
My solution will give the first result, yours the second.

Thomas
0
 
Naresh PatelTraderCommented:
Yes sorry I dint  notice that my bad.
0
 
RWayneHAuthor Commented:
Thanks for the help. -R-
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.