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 :)
Repellendus qui aut nobis ab. Voluptas nihil sapiente sunt qui. Laborum vel maxime ducimus quia voluptas. Ut est dolorum totam consequatur est ad. Fuga adipisci quisquam modi nihil.
Ut incidunt id earum sint accusantium et cum. Sit placeat id sint. Quia sint suscipit nulla itaque quos voluptates alias omnis.
Veniam et velit modi voluptatem quisquam. Enim dolore fugiat porro odio illo et vero perspiciatis. Consectetur rerum voluptatem ex consectetur sequi adipisci omnis.
Dolores qui et nihil ut et adipisci. Ducimus omnis ipsum suscipit labore quibusdam est nihil. Voluptatibus iusto ab voluptas consequatur quasi sequi. Nam et illum iure est sequi totam inventore.
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...