| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I capitalize the first letter of multiple cells?
Otto,
You ROCK!!!!!!!!!!!!!!!!! "Otto Moehrbach" wrote: Let's say that your names are in Column A starting with A2. Find a blank column to the right of all your data, say Column H. In H2, type "=Proper(A2)" without the quotes. Drag that formula down as far as the names in Column A go. Click Edit - Copy. Select A2. Click Edit - Paste Special - Values. Click OK. Delete Column H. Done. HTH Otto "dominic_howden" wrote in message ... I'm trying to clean a mailing list (1000+ rows), but the capitalization of the cells containing name, salutation etcetera is variable. How can I ensure that the contents of all cells start with a capital letter? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create multiple sheet tabs from multiple cells. | Excel Worksheet Functions | |||
| Divide a number into multiple cells | Excel Discussion (Misc queries) | |||
| Problems comparing data from multiple blank cells | Excel Worksheet Functions | |||
| count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
| how can i ignore blank cells when multiple cells? | Excel Worksheet Functions | |||
Threaded Mode
