VBA - Delete hidden spaces in blank cells

[rafapmotta]

Hi guys,

Would like to know if any of you know a code that could help me to clean the hidden spaces in blank cells.

I already have one code, but when I execute it through a data column, it changes the day into month and month into day.

Follow below my code:

Dim LRi As Range, cell As Range

Set LRi = Range("A2:N" & Range("A2").End(xlDown).Row)
For Each cell In LRi
cell.Value = Trim(Replace(cell.Value, ",", "."))
Next cell


Thanks

[rafapmotta]

Actually, a code that trims all cells inside range E2:G500, would solve my issue, but I have no idea how to do this

[stnkynts]

The Replace part is what is messing up your days/months. You don't need it for what you have described.

Please Login or Register  to view this content.

Note: This isn't the most efficient way to do this but will work for your needs