| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
capitalizing first letter of a word in columns
I need to capitalize the first letter of each work in a roll of 110 columns
and I really don't want to go to them one at a time Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
capitalizing first letter of a word in columns
You can use the Proper function
In Cell A1 you have "hello world" in Cell B1 =Proper(A1) will return "Hello World" -- HTH... Jim Thomlinson "Tigger" wrote: I need to capitalize the first letter of each work in a roll of 110 columns and I really don't want to go to them one at a time Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DELETE ALL EXCEPT LETTER OF A WORD | Excel Discussion (Misc queries) | |||
| Fisrt letter of every word | Excel Worksheet Functions | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| Capitalizing first word only... | Excel Worksheet Functions | |||
| How do I get the first letter of a word in excel | Excel Discussion (Misc queries) | |||
Linear Mode
