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.
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.