| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help making the first letter of Cell capitol
I am making a list of names and need to make the first letter in each cell a
capitol. How do I do this, also I'm a beginner with excel. My computer has Excel 2003 installed |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help making the first letter of Cell capitol
Single names in the list?
Assuming your list is in A1:A20 In B1 enter =PROPER(A1) Copy that down to B20 double-clicking on the bottom right corner of B1 When happy, copy B1:B20 and in place, editpaste specialvaluesokesc. Delete the original column A. Gord Dibben MS Excel MVP On Sat, 10 Nov 2007 19:01:34 -0500, "Dan" wrote: I am making a list of names and need to make the first letter in each cell a capitol. How do I do this, also I'm a beginner with excel. My computer has Excel 2003 installed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a letter have a value | Excel Worksheet Functions | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| Making a letter equal 1 formula | 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 | |||
![Dan[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
