Forum Discussion
Solved
error importing excel cells starting with equals sign
I am loading Excel files from a folder in power query. In one of the text columns, some records start with "=". Example: "= Number of people" This produces a #Name type error. When opening the ...
Hello:
I have solved the problem whit this macro based on Vijay_A_Verma proposal:
https://1drv.ms/x/s!ApCA2Iz4chbHmDbhSxSdK4OoEPbn?e=Mu7CzX
I hope it helps people with the same problem.
Thank you very much Vijay.
I will implement your solution in a VBA macro.
It's a shame that the Excel.Workbook function doesn't have more parameters. Or return more information besides "data" and "kind". It would be great if you could import: formulas, cell color, font type, etc.
So we could handle this problems at PQ level.
Maybe for future versions. 🤔