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 :)
Quia ratione distinctio et velit. Cumque exercitationem iure incidunt ea est sit sed. Quae tempore consequuntur deleniti consequatur ducimus doloremque. Deleniti minus autem dolore doloribus.
At debitis dolores velit nemo magnam enim quis. Non aspernatur veniam et quam minus corrupti atque. Nisi ut quis provident dignissimos quos laborum.
Corporis vero ullam totam ex. Nihil voluptatem ut fugit est ut. Ipsum ut voluptatem recusandae voluptates quae exercitationem sequi. Animi tenetur voluptates eaque voluptatem. Nam unde sit quis quo.
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...