| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change all text on Spread sheet
Hi
I have Excel 2007, I have a Spread sheet with a few hundred lines and six columns, the sheet contains cells with text and numbers, sometimes in the same cell but mostly in separate cells. The text has all been entered in CAPS, and I need to alter it for better appearance. Is there some way I can automatically change the Caps to lower case but leaving the first letter on each word in caps? All help appreciated. Regards Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to change the column width on a spread sheet? | Excel Worksheet Functions | |||
| Is there a way to change all dates in a spread sheet | Excel Discussion (Misc queries) | |||
| Change the sign on all numbers in a spread sheet | Excel Discussion (Misc queries) | |||
| HOW DO YOU CHANGE AN ENTIRE SPREAD SHEET FROM LOWER CASE TO UPPER | Excel Discussion (Misc queries) | |||
| How do I change spread sheet data into address labels? | New Users to Excel | |||
![Daniel[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
