Upper Case Letters to First Letter Upper, Remaining Letters Lower
in [General]
|
Prev: Transport row`s data into separate etiquettes
Next: Upper Case Letters to First Letter Upper, Remaining Letters Lo
From: SueW on 24 Feb 2010 09:38 How is this done in Excel 2007?
From: Jim Thomlinson on 24 Feb 2010 09:46 Use the proper function. =Proper(A1) -- HTH... Jim Thomlinson "SueW" wrote: > How is this done in Excel 2007?
From: KC hotmail com> kcrippstein on 24 Feb 2010 09:54 The formula =PROPER(A1) will make every first letter of each word upper case and the rest of each word lower case. A1 is the cell you want changed to upper/lower. So QUICK BROWN FOX becomes Quick Brown Fox. If you wanted "Quick brown fox," that cannot be done via formula. A period may or may not be the end of a sentence, and certain words in the middle of a sentence may need to be capitalized, so this is just too complicated. Excel can do =UPPER, =LOWER, or =PROPER. -- Please remember to indicate when the post is answered so others can benefit from it later. "SueW" wrote: > How is this done in Excel 2007?
From: Gord Dibben on 25 Feb 2010 12:32
=PROPER(LEFT(A1,1))&LOWER(MID(A1,2,255)) Returns............Quick brown fox Gord Dibben MS Excel MVP On Wed, 24 Feb 2010 06:38:05 -0800, SueW <SueW(a)discussions.microsoft.com> wrote: >How is this done in Excel 2007? |