Forum Discussion
Power-Query: convert cell formula to text whiel there is a formula error
I have an "incorrect" sheet where text cells contain values like =+@GF+@ ABC =+@GF+@ HELLO =+@GF+@ XYZ Those are interpreted falsely as fromula and create #NAME? errors Correct content wo...
Here is the shortened file. Nothing special on the content, except that error (cells F2:F3) which I want to correct while importing to PQ.
Fix could be done if I am opening the file and do a search/replace as mentioned above. After that, the file works fine.
But I want PQ doing the search/replace... and I never get that far..
I guess it's really the loading procedure which tries to prevent errors being loaded at the first place.
