Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change case in excel? MS Help is no help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change case in excel? MS Help is no help
Try the =proper() function...
If the text that you want to represent a change to the format of the letter characters is found in cell A2 the correct syntax would be Proper case =proper(A2), Upper case =upper(A2), Lower case =lower(A2) -- Thanks for your help - Joe Mac "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change case in excel? MS Help is no help
Use the function PROPER.
If your text string is in A1, then =PROPER(A1) will yield proper case. -- Brevity is the soul of wit. "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 |
#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 |
Reply |
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 |