Please refer to attached file. The content is the result of importing data from another application.
I´ve been trying to convert text to number on column E, via various methods (cell formatting, TRIM, CLEAN formulas, etc ). Nothing has worked. Then I discovered something, that may what´s causing the problem: with cursor on cell E1, if I press F2 and then click on the formula bar, I notice that the cursor blinks 2 or more positions to the right of the text. I conclude that there is garbage there, which is preventing the above mentioned method to work as expected.
So, I think a macro would help to do the job. I kindly ask for your help with the macr, or other effective way to deal with this issue. Book1.xls