Forum Discussion

Archie2024's avatar
Archie2024
New Member
2 years ago
Solved

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

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!

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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