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