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 :)
Eum officiis doloremque adipisci voluptatem adipisci doloribus mollitia. Repudiandae ex voluptatum officiis consequatur corporis vero. Odio libero ex inventore qui id.
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...