LinkBack URL
About LinkBacks
Hi there I know the PROPER function will convert all text to capitalise each word, is there a formula that can convert only the first letter to caps and the rest to lower case?
Thanks
Simon
Hi there I know the PROPER function will convert all text to capitalise each word, is there a formula that can convert only the first letter to caps and the rest to lower case?
Thanks
Simon
Last edited by simjambra; 03-12-2009 at 08:31 AM.
I am no formula expert so you may get a better answer than mine
=UPPER(LEFT(A1,1))&MID(A1,2,LEN(A1)-1)
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
It's a long way to go, but it works:
=PROPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
EDITED after seeing mudraker's take on just doing the first letter, much better.
Last edited by JBeaucaire; 03-12-2009 at 07:00 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I did not convert all the rest to lower case as requested
=UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1)-1))
Wonderful, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks