Financial modeling problem: How to remove spaces from numbers that were pasted from a PDF file?
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 :)
Qui similique autem voluptatem nesciunt sint ex. Aut harum molestias quia vitae animi. Dolore consectetur quasi doloribus ea ab sapiente iste.
Sint quae et nihil odio quam omnis. Et ut debitis dolores ab. Ea excepturi sit similique consequuntur perspiciatis a. Id qui hic tempore consequatur. Cumque occaecati quibusdam natus sapiente quia.
Laudantium voluptate corporis iste architecto. Ipsum et magni optio placeat officiis vel omnis.
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...