VBA - Delete space (cell start)

[VBA]

Heya,

I often have to work in Excel-spreadsheets which provide values to me in a rather unpractical way. For some reason, every cell entry starts with a space, followed by the value. It makes it impossible to start calculating with the values right away.

I tried

replace: " " with: ""

But that way all the spaces in the sheet are removed, not just the spaces at the start of each cell. I would like to avoid that, as it makes the descriptions a bit difficult to read...

So, any ideas on how to write a little macro (or a tric in Excel itself) which I can use to quickly get rid of those spaces and start calculating?

Thanks in advance.

 

[VBA]

That works wonderful

Thanks a lot for your time and effort Really appreciated.