Say I have a sheet, where the cells are mostly numerical characters only, but some cells unfortunately also contain "*".
I am new to VBA or macros in general and tried this:
Dim c As Range
For Each c In Selection
c.Value = Replace(c.Value, "[^0-9.,-]", "")
My intent is to remove all non-numeric characters except ".","-" and ","
Either the code is faulty or my way of applying it is wrong. Any help?