Excel is automatically removing trailing spaces

[ax1lla]

Hey all - so we are having a very odd behavior with excel. Here are the facts.

We have a macro at our work where we paste an email into a worksheet. We run a macro and it takes that email and formats it nicely into another worksheet. This has worked for years without an issue. Easy stuff.

Recently, my work has made us upgrade to office 365. Now....the macro is not running correctly because Excel is removing trailing spaces on some of the cells (and the macro needs them to have a space at the end).

The odd thing here is....its working fine for one of my colleagues (not removing the space). But, for us other two.....its removing it. We all use the same file btw - on a network drive.

Any ideas on why this would happen and how to fix it?

 

[ranman256]

trailing spaces are insignificant and are removed.
if you want to keep them, try putting in quotes :
"my words "

 

[ax1lla]

They are not insignificant to me. It is an inconsistent behavior for Excel to NOT remove it for two of us...but keep them for another. We are pasting an email in from outlook (and it contains spaces). I know I can put in code to remove space and then change my code to reflect this, but....it still irks me that Excel is removing stuff seeming randomly......