Code in macro

[kath75]

Good Afternoon,

I need a formula to take commas out in one column from my item descriptions. Is there a way to do this so I don't have to do it every
time and it comes over with them remove?

Thank you

 

[mole999]

if you run the macro recorder and record find replace for commas, stop the recorder and look at the code. if it need tweaking you might post it back to the forum

 

[kath75]

that did not work. any other ideas?

 

[Logit]

.
Paste in Routine Module :

Option Explicit


Sub NoCommas()
    Dim c As Range
    
    ActiveSheet.UsedRange.Select
    
    For Each c In Selection.Cells
        c = Replace(c, ",", "")
    Next
    ActiveSheet.Range("A1").Select
    
End Sub

Download workbook : https://www.amazon.com/clouddrive/share/8kvcL7hlVLckD4lIBQz5TQQDXe7OWCAWHddLriVzdvp

 

[mole999]

that did not work. any other ideas?

interested to know what result you did get

 

[MARK858]

if you run the macro recorder and record find replace for commas, stop the recorder and look at the code. if it need tweaking you might post it back to the forum

I think you also needed to say to make sure "Match entire cell contents" isn't checked.