| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change case in excel? MS Help is no help
What part of the Help is giving you trouble?
If the TEXT STRING is in A1, in A2 enter =PROPER(A1) to produce Text String in A2 You can copy this formula to other rows and columns. When happy with results, select all the cells with formulas and Copy them. EditPaste SpecialValuesOKEsc. Now delete the original data. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 04:13:01 -0700, philippos wrote: I want to be able to change capital letters into title case. A colleague and I have tried to follow the instructions given by the online Help but cannot figure out how to make this work. The instructions are not very well explained |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion of Numercials to Figure | Excel Worksheet Functions | |||
| VBA Code | Excel Discussion (Misc queries) | |||
| spell number | Excel Worksheet Functions | |||
| How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Threaded Mode
