| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete commas in spreadsheet but not in formulas
Right-click on first sheet tab and "Select all sheets"
CTRL + a(twice in 2003) on activesheet. F5SpecialConstants checkmark in "Text" and OK EditReplaceOptionsWithinWorkbook Replace what: , Replace with: space or nothing Replace all. Right-click on the sheet tab and "Ungroup sheets" Gord Dibben MS Excel MVP On Tue, 23 Jan 2007 16:26:01 -0800, cynwalker wrote: I have a giant workbook someone gave me and I need to take all of the commas out of the text but not out of the formulas. Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I clear contents from a spreadsheet but not the formulas | Excel Discussion (Misc queries) | |||
| Cannot select checkbox to delete it from a spreadsheet | Excel Discussion (Misc queries) | |||
| delete all the spreadsheet | Excel Discussion (Misc queries) | |||
| Update all formulas on spreadsheet - Apr05! to May05! | Excel Discussion (Misc queries) | |||
| Find and delete part of formula for multiple formulas? | Excel Worksheet Functions | |||
Hybrid Mode
