Remove special characters from string - apply to multiple cells

I found this bit of code here and it works as needed, but only in one cell.

I've attempted a few different things to make it apply to A2, A3, A4 at the same time, but once I add anything past the first cell, it stops working.

Please Login or Register  to view this content.

I like the above code, but also had found this which works too, but I ran into the same problem of not being able to apply it to multiple cells.

Please Login or Register  to view this content.

Any help is greatly appreciated.

This line right here is making so it only works on cell A1:

Please Login or Register  to view this content.

I would not suggest soley removing it but instead expand the range in which you allow the worksheet change event to work on. Something like this:

Please Login or Register  to view this content.

The rest of my post was cut off somehow.

I also had that I used a second working example, but it also only applied to a single cell and not a range. A2,A3,A4

Please Login or Register  to view this content.

Thanks