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.
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalPQ reads the value not formula. Hence, you can not handle this at PQ level. This has to be handled at source level only.
To handle at source level i.e. in Excel file (Save a backup of your Excel file first)
1. Select the column
2. Press CTRL+G to open Go To Window and click Special
3. Click Formulas and check only Errors and OK. This will select only error cells (if you are having other errors also, then those will also get selected. This is an unintended outcome of this)
4. CTRL+H and put = in Find what: box and press Replace All