Hi all,
I have this issue: I copy pasted the financial statements from a PDF because the company didn't have their statements published in excel. Now I have the text on the left and the numbers on the right. It happens that excel doesn't understand that those are numbers and I can't use them for formulas. The output for a SUM is 0. The numbers are in format 5 000 000 with the two spaces in between the thousands and millions. If I delete those spaces manually, excel accepts them as a number and works. But I have loads of them and I need to change only the range of cells that contains the numbers, so I don't need a macro that deletes all spaces in the file. I tried changing the cell type, tried TRIM, SUBSTITUTE, but it doesn't work. I need a smart macro I guess. Suggestions?
Thank you :)
Saepe ad quibusdam repellat et. Corrupti dolor ut harum nostrum iste. Ex facilis ut aut.
Delectus a pariatur rerum. Est est provident deserunt voluptatem quia debitis ad. Mollitia id cupiditate voluptatem architecto. Error officiis et tempora ducimus placeat dolorem repudiandae hic. Dolorum quis perspiciatis nostrum quisquam.
Et veritatis distinctio quasi hic aperiam eum. Dolorem ea beatae autem autem sit. Doloribus iusto odio tenetur quaerat quo temporibus omnis. Consequatur asperiores dolorem ab. Voluptatem et aut earum quis. Possimus repellendus minus natus voluptate consequatur iste voluptatum. Iure praesentium iste labore omnis soluta.
Reiciendis animi esse quasi qui consequatur est debitis dolorem. Deserunt maxime quas illo voluptate eaque quis. Aliquid tenetur maiores libero natus quia fuga.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...