Remove Blanks Rows and Columns after Exporting Data to Excel

[francoiscj1]

I have an Excel sheet with blank rows and columns after exporting data to Excel using columns A:S. I would like to remove the empty rows and columns. Thanks for the help.

 

[sheetspread]

A non macro method would be to write a 1/counta formula and drag across/down, then with F5(Goto) - special highlight the errors and delete.

 

[sheetspread]

If the blanks are actually invisible strings then a sumproduct/len formula or countif with wildcard (which won't work with numbers) can be used in place of counta