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 :)
Atque neque perspiciatis atque eaque. Rerum repellat in perspiciatis. Consequatur non suscipit rem reprehenderit.
Ut fugiat commodi cum reiciendis. Sint laborum impedit tempora quis non in sequi. Esse ut enim iusto at accusantium vel rerum. Quia qui sit eligendi incidunt optio. Pariatur commodi impedit quisquam veniam.
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...