| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Format Cell - first letter upper case
Is there a way to format a cell so that when I type in "john" it wil
display as "John" Or if I type in "jOhN" it will display as "John" The PROPER function works if I refernce it to another cell. I also want to format a cell to display a Canadian Postal Code so tha when I type "v9t5t1" it will display as "V9T 5T1" with a space betwee the T and the 5. Thank you -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Upper Case Letters to First Letter Upper, Remaining Letters Lower | Excel Discussion (Misc queries) | |||
| 1st letter upper case | Excel Discussion (Misc queries) | |||
| Format cell to convert to Upper case | Excel Discussion (Misc queries) | |||
| how do I format a cell to display its contents in Upper case? | Excel Discussion (Misc queries) | |||
| How do I change Letter case (lower to Upper) in a spreadsheet??? | Excel Discussion (Misc queries) | |||
Threaded Mode
