| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
| Pulling a Letter from a cell and filling another cell with info | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| if a cell = a particular letter or even contains that letter | Excel Worksheet Functions | |||
Linear Mode
