How do I get First-Letter cap in a cell?
 

I'd like to be able to type names into a sheet quickly, and not have to hit
the cap on the first letter. I can't figure out how to do this. I'd like to
somehow set-up a cell so that whenever someone types in it the first letter
of the text is capped. Thanks.

How do I get First-Letter cap in a cell?
 

I'm not sure how to set up a cell so that it automatically formats the case
into proper form. I do know how to format the cell after it's been
entered...by using the "=proper(text)" function.

It's an extra step, but maybe it'll get you by until you get your answer.

"DeeDeeCee" wrote:


I'd like to be able to type names into a sheet quickly, and not have to hit
the cap on the first letter. I can't figure out how to do this. I'd like to
somehow set-up a cell so that whenever someone types in it the first letter
of the text is capped. Thanks.

How do I get First-Letter cap in a cell?
 

That seems the best way/ If entering text into column A, put the formula in
column B as =A2 and copy down. Once done, copy column B, paste special -
Values, and delete column A.

"KerryM1212" wrote:

I'm not sure how to set up a cell so that it automatically formats the case
into proper form. I do know how to format the cell after it's been
entered...by using the "=proper(text)" function.

It's an extra step, but maybe it'll get you by until you get your answer.

"DeeDeeCee" wrote:


I'd like to be able to type names into a sheet quickly, and not have to hit
the cap on the first letter. I can't figure out how to do this. I'd like to
somehow set-up a cell so that whenever someone types in it the first letter
of the text is capped. Thanks.