change content in a cell

[Schnet]

I have a column with numbers in that format:
289-231-5274
but I need them without the "-"
How can I change that with the help of a macro?
Thanks
Schnet

 

[just_jon]

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> DashZapper()
Application.ScreenUpdating = <SPAN style="color:#00007F">False</SPAN>
<SPAN style="color:#00007F">With</SPAN> Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row).SpecialCells(xlCellTypeConstants) <SPAN style="color:#007F00">'</SPAN>
    .Replace What:="-", Replacement:="", LookAt:=xlPart
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN>
Application.ScreenUpdating = <SPAN style="color:#00007F">True</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>

 

[Schnet]

Thank you very much!
Would you mind to explain me how that exactly works?
I worked with macros before but I'm still a beginner.
Schnet

 

[just_jon]

Thank you very much!
Would you mind to explain me how that exactly works?
I worked with macros before but I'm still a beginner.
Schnet

The code simply calls Excel's native Replace function; the only thing "special" about it might be the designation of the range to search - it is limited to

a] column A only, and

b] only those cells having constant values - no formulas and ignore blanks, too.

Screen updating is turned off then back on because

a] you don't really need to see the screen flicker when it runs, but more importantly

b] it should run faster not having to update the screen but 1 time, when finished.