Automatic initial capital letters

[chash]

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

 

[David McRitchie]

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

 

[chash]

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