1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Extract data from Power Query

Hi, I've been fighting with powerquery (pq) bc I need to extract specific numbers from a pdf, it has hundreds of pages and the numbers are always at the same spot, but they're not spreadsheets, they're invoices.

I've tried pq but it makes nonsense sheets trying to convert the text to a normal sheet, but I can't find how to keep just the number I need and toss the rest of the info

submitted by /u/sbeveguy
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI-powered spreadsheet