Forum Discussion

JOLBR's avatar
JOLBR
New Member
5 years ago

Identical Excel formula = Different results in PowerQuery

Hi,    I am a bit confused about this.    I have an identical formula in 2 different, but comparable Excel Workbooks. The formula is as follows TEXTJOIN("-";TRUE;C12:L12)   Howe,ver when loadin...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

JOLBR 

Is there any blank cells between C12 to L12 in row 2, try change the data type to only text in power query, blank(text), null, and 0 can miss identified and could bring errors in PQ. 

 

Paul Zheng _ Community Support Team

  • JOLBR's avatar
    JOLBR
    New Member
    5 years ago

    Hi Paul, 

     

    Thanks for the suggestions. 

     

    There are blank cells in the range, but there are blank cells for both files. That is why I do not understand why one file works while the other fails in loading that particular cell value. 

     

    Tried changing the resulting cell to "text" but that did not help. 

     

    However what did help was to, overwrtie the function --> save the file --> open the file again --> copy  the function from below cell (identical) and save the file agian. Then the cell was loaded correctly in PQ