Today I spent time working out why I could not convert some text values I had pasted from a FR report to Excel into numbers. It turns out the text values were padded with non breaking spaces which TRIM() did
How to Convert Text Number to Values in Excel
