Thread: delete commas in spreadsheet but not in formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote