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


G

Guest

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.
 
Ad

Advertisements

G

Guest

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.
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top