If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatic initial capital letters
I am using Excel to enter a lot of names, and wondered
whether there was a way of ensuring that the initial letter of any cell would be a capital letter, so that I don't have to press SHIFT every time - I sometimes miss the capital out as I release the shift key too soon ! Any help would be greatly appreciated |
#2
|
|||
|
|||
Automatic initial capital letters
See
http://www.mvps.org/dmcritchie/excel/proper.htm Your question is somewhat in conflict, though I'm pretty sure that you want Proper Case (Title Case) where the first letter of every word is capitalized, and you want this done as soon as you enter the data. Subject indicates automatic. Body indicates initial letter of a cell (not a word) -- sentence case, but sentence case would capitalize the next letter after and end of sentence period. Lots of names implies (each word not just start of a cell) -- proper case, which is what I think you really want. Anyway all of the answers are within http://www.mvps.org/dmcritchie/excel/proper.htm and for automatic you need a macro (event macro). I would prefer to use the proper_case macro myself and invoke it only when needed on a selection as there are usually exceptions. i.e. McRitchie --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "chash" wrote in message ... I am using Excel to enter a lot of names, and wondered whether there was a way of ensuring that the initial letter of any cell would be a capital letter, so that I don't have to press SHIFT every time - I sometimes miss the capital out as I release the shift key too soon ! Any help would be greatly appreciated |
#3
|
|||
|
|||
Automatic initial capital letters
Thanks for that, you have helped me no end, although I
can see the point in the Mc thingy, that is not an issue with me, so I have used your macro that includes cell.Value = Application.proper(cell) that appears on another discussion board, that you have a link to on your web page. It works a treat, and greatly improves my keying-in times !! Chas |
Thread Tools | |
Display Modes | |
|
|