delete commas in spreadsheet but not in formulas
 

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?

delete commas in spreadsheet but not in formulas
 

Select the range to fix.
Edit|Goto|special|check Constants
(and uncheck Numbers, Logicals, Errors????)

Now your original selection has been reduced to just the cells with constants.

Edit|replace
what: , (comma)
with: (leave blank)
replace all

Be aware that if you have a string like:
12,32341,1,23,12

it'll come out as a number (not text)

And if your string is:
12,32341,1,23,12,111111111111111111,1111111111

Your string will be converted to a number with only 15 significant digits.



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?

--

Dave Peterson

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?