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...
DanHuber Difficult to visualise without seeing the file, but you can right-click on a column header in PQ and select 'replace values'. Enter the @ sign and replace it with 'nothing' (thus leave it blank). That should resolve it.