Forum Discussion
Remove Error not working
I'm extracting data from excel where there are #REF errors in the spreadsheet. For some reason remove errors will not remove them. So far I have tried: Remove errors function from remove rows D...
Hi Anonymous ,
I already saw that link and followed the solution which was to replace rows. As shown above this doesnt work.
Kind regards,
Colleen
Hey Colleen,
Follow all the steps in the link. Replace with value "null". Then right click on the column header and select "Remove Empty"...worked for me
Regards,
L