Hi All,

I stumbled onto this thread as I had a similar query (which has been answered now thanks to tstav ).

tstav, brilliant code. Just one query, how does the following line work?

[vba] 'Remove double spaces from within cell content
cel.Offset(0, 1).Value = Replace(cel.Offset(0, 1).Value, " ", " ") [/vba]
It seems to be replacing " " with " " i.e.e the same thing. This is just for me to learn and understand VBA better.

Thanks