I have a spreadsheet with numbers with dashes in them (5124-01 or 92653-856).
Is there a way I can delete the "-" from the cell without editing every cell?

Highlight the column Edit Replace type the hyphen in the Find What:
window, and leave the Replace with: window blank ReplaceAll..........

Vaya con Dios,
Chuck, CABGx3



"MJ" wrote:

I have a spreadsheet with numbers with dashes in them (5124-01 or 92653-856).
Is there a way I can delete the "-" from the cell without editing every cell?

If A1 contains 123-456 then:
=SUBSTITUTE(A1,"-","") will return 123456
--
Gary's Student


"MJ" wrote:

I have a spreadsheet with numbers with dashes in them (5124-01 or 92653-856).
Is there a way I can delete the "-" from the cell without editing every cell?

Select data and use Edit==Replace

Find What: - (== the dash/minus sign)

Click "Replace all"

HTH

"MJ" wrote:

I have a spreadsheet with numbers with dashes in them (5124-01 or 92653-856).
Is there a way I can delete the "-" from the cell without editing every cell?

Yes there is. You must record a macro. If you know how to record one,
great! but just in case I'll describe as best I can.

During the macro recording process, you CAN NOT use your mouse. It
will record only keystrokes.

Make sure you have selected the first cell to be edited. (Don't double
click it, just select it)
Go to Tools - Macro - Record New Macro
Assign a keyboard shortcut for it.
Then you will see the little window with a button to press to stop the
macro recording process on your worksheet.
Press F2 and that will allow you to edit the cell
Then press your arrow keys to move your insert point to "-"
Delete the "-"
Press enter
Press the stop button on the macro window.

You will have to record two seperate macros since you have two
different formats for your cells.

Then you just press ctrl+ whatever shortcut key you selected, and it
will perform that action to every cell you ask it to.