Power-Query: convert cell formula to text whiel there is a formula error

@hanks for the ideas. Unfortunately, it did not work. Most likely because I do not get the "bad" cells into PQ anyway. I noticed, while testing, that the import is not importing that cells at all. instead, I end up with cells that contain #Name? instead. 

So, I have a file that oviously was created by a database export or such. As son as i do a save (i.e. to csv) or a PQ import, the cells are evaluated the first time, I guess.. 

What i do is the following:

1 - opening the file in excel, selecting the cell

2 - see what's in that cell

3 - do a search and replace

4 - result is that the error in the cell is gone...

NOW I can import it in PowerQuery...

Weird, isn't it?

If I import the file in PQ without that search/replace before in plain excel, I only get the cell content of #Name? in that very cell..

Any ideas?

Dan