| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
now that i have formatted the text to "proper" ...
is there a way to remove the cells that are still in all caps without losing
the "proper" column? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
now that i have formatted the text to "proper" ...
Hi,
2 ways. 1. Hide the column with the capitalised words in. or 2. Copy the 'Proper' colmn and paste it back over itself using Edit|Paste special paste values then delete the capitalised column Mike "catjea2000" wrote: is there a way to remove the cells that are still in all caps without losing the "proper" column? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
now that i have formatted the text to "proper" ...
Yes.
Copy the the column with the PROPER formulas. EditPaste Special(in place)ValuesOKEsc. Now delete the original column. Gord Dibben MS Excel MVP On Sat, 13 Sep 2008 11:46:01 -0700, catjea2000 wrote: is there a way to remove the cells that are still in all caps without losing the "proper" column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSV file doesn't save "xEy" style number as text formatted data | Excel Discussion (Misc queries) | |||
| Excel should support a proper inverse to "Text to columns" | Excel Discussion (Misc queries) | |||
| Text formatted as "General" in Excel 2002. How do I avoid that? | Excel Discussion (Misc queries) | |||
| Use "PROPER" to change UPPERCASE text to Title Case on worksheet | Excel Worksheet Functions | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
Hybrid Mode
