Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: how do i extract data from a pdf file using power query in excel? please this is what i get trying to implement for 1.2. the other values are giving me invalid answers Re: how do i extract data from a pdf file using power query in excel?hi Lz! I saw Pdf Tables in column name after loading the code, how then do i locate it. Thanks for the feedback.Re: how do i extract data from a pdf file using power query in excel?wow.....so there is no ad ins i can install to access this with 2019 version?how do i extract data from a pdf file using power query in excel? hi team, Please i would like to find out if there is a way to extract data from a pdf file using power query in excel? regards!! Re: power query - data cleaning and analysis Your method worked perfectly but failed to split the headings. i also applied the same method to a different data with the same problem and the results were not up to expectation but with "text to column" it worked in all the different data it was applied to. SergeiBaklan Re: power query - data cleaning and analysis i am talking about the fixed width feature as shown belowSergeiBaklan Re: power query - data cleaning and analysisi would appreciate it so much if the excel "text to column" feature is incorporated into power query in later versions.Re: power query - data cleaning and analysisWOW!!! that was very impressive. How do i accurately specify the positions? it seems to me like a tedious taskpower query - data cleaning and analysis Hi Team, Please the attached excel workbook contains two sheet namely "system data" which was generated from a system and the second sheet "transformed" which was generated using "text to column". i would like to know if i can achieve the same transformation using power query. Solved
