Import PDF report to Power Query, but reading numbers as Text with blank spaces in between

[Archie2024]

Hi,  I imported a PDF report into PQ. The columns read as text, and I can't convert type to numbers. It gives me an error. Also, there are blank spaces between the numbers. How do I fix the empty space and convert it to a number type?

Any help would be much appreciated.

Thanks!

[Anonymous · Accepted solution]

For each column, You can select a value by right clicking any cell and choosing Replace value. For the value to replace box, type a space. For the Replace with box, leave it empty. Now you have no spaces and you should be able to convert those values.

--Nate

[Archie2024]

Genius! Thank you so much! It worked!