Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

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?
0
RWayneH
Asked:
RWayneH
  • 4
  • 2
  • 2
  • +1
1 Solution
 
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now