Upper Case Letters to First Letter Upper, Remaining Letters Lo
in [General]
|
Prev: Upper Case Letters to First Letter Upper, Remaining Letters Lower
Next: How to have charac in new column with 40 char length only...
From: Jim Thomlinson on 24 Feb 2010 10:12 =upper(left(A1), 1) & lower(mid(A1, 2, 100) Will turn generate "Quick brown fox" -- HTH... Jim Thomlinson "KC" wrote: > 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: KC hotmail com> kcrippstein on 24 Feb 2010 10:19 Yep, sure :) I was trying to point out that if it's not just one sentence, or if it has periods in a single sentence, or if something in the middle is supposed to be capitalized, that would not be accommodated. I should have provided a better example, like "Dr. Jones thought tumors, cysts, etc. would be easy to deal with." -- Please remember to indicate when the post is answered so others can benefit from it later. "Jim Thomlinson" wrote: > =upper(left(A1), 1) & lower(mid(A1, 2, 100) > Will turn generate "Quick brown fox" > -- > HTH... > > Jim Thomlinson > > > "KC" wrote: > > > 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: SueW on 24 Feb 2010 10:41 I cannot get this to repeat in the cells I need it to. I can get the formula to work in one cell, but I have 35,951 entries I need to change from all upper to Upper, lower, and they each contain a different last name. "Jim Thomlinson" wrote: > Use the proper function. > > =Proper(A1) > -- > HTH... > > Jim Thomlinson > > > "SueW" wrote: > > > How is this done in Excel 2007?
From: Fred Smith on 24 Feb 2010 12:08
You just need to copy the formula down the column. Assume your names are in column A, with no blank rows. Enter the formula you were given in B1. Now, double-click on the fill handle (the small square at the bottom right of the cell). Voila, the entire column will be populated with proper names. Regards, Fred "SueW" <SueW(a)discussions.microsoft.com> wrote in message news:91C3201C-CEBD-45C9-8810-6737CF536CC7(a)microsoft.com... >I cannot get this to repeat in the cells I need it to. I can get the >formula > to work in one cell, but I have 35,951 entries I need to change from all > upper to Upper, lower, and they each contain a different last name. > > "Jim Thomlinson" wrote: > >> Use the proper function. >> >> =Proper(A1) >> -- >> HTH... >> >> Jim Thomlinson >> >> >> "SueW" wrote: >> >> > How is this done in Excel 2007? |