| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Change Case from Mixed to Caps
PERFECT! Thank you!
"Roger Govier" wrote: Hi Kathy Copy your new column which has the formulaePaste SpecialValues That will "fix" the formulae to their resulting text appearance. You can then delete the original column. -- Regards Roger Govier Kathy wrote: Thank you! This works but now I need to get rid of the column with the improperly formatted case (so that there are not two duplicate columns of text). How can I do that? Can I turn the new column with the "Upper" and "Proper" formulas into text? "Pritesh" wrote: You can apply "Upper" formula, even better would be to use "Proper" formula, which capitalizes only first letter of each word from the reference data/cell. It works like; =upper(a1) and =proper(a1) Regards, Pritesh "Kathy" wrote: Please help! I have a number of imported worksheets with some fields formatted in mixed case and some in UPPER case. I want all data to look consistent. Is there a way that I can quickly turn all of the mixed case to upper case? Word has a button to do this but I don't see one in Excel. Thanks in advance. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING | Excel Discussion (Misc queries) | |||
| How do I change from all caps to proper case? | Excel Discussion (Misc queries) | |||
| How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
| Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
| How to change case on a spreadsheet from Caps to Sentence? | Excel Discussion (Misc queries) | |||
![Kathy[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
