| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Upper Case Letters to First Letter Upper, Remaining Letters Lower
How is this done in Excel 2007?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Upper Case Letters to First Letter Upper, Remaining Letters Lower
Use the proper function.
=Proper(A1) -- HTH... Jim Thomlinson "SueW" wrote: How is this done in Excel 2007? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Upper Case Letters to First Letter Upper, Remaining Letters Lo
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Upper Case Letters to First Letter Upper, Remaining Letters Lo
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" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Upper Case Letters to First Letter Upper, Remaining Letters Lower
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Upper Case Letters to First Letter Upper, Remaining Letters Lo
=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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Upper Case Letters to First Letter Upper, Remaining Letters Lo
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Upper Case Letters to First Letter Upper, Remaining Letters Lower
=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 wrote: How is this done in Excel 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF and VLOOKUP with upper and lower case letters | Excel Worksheet Functions | |||
| How to change lower to upper case letters? | Excel Discussion (Misc queries) | |||
| change lower letters to upper letters | Excel Discussion (Misc queries) | |||
| How do I create upper/lower case letters in cells? | Excel Discussion (Misc queries) | |||
| Count the occurance of upper or lower case letters | Excel Worksheet Functions | |||
Hybrid Mode
