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

Similar Threads

excel case changes on a column of first names 2
I cant seem to figure out how to use Proper in excel. The help op. 1
capitlization of the first letter of words in a form text box? 2
How can I hide letter in a cell? 2
drop cap in text block 1
How do I get a letter in one cell ito equal a number in anotherl.. 4
Changing text from all caps to first letter cap 2
first letter cap ?? 4

Top