I have a large set of .csv files distributed across many subfolders of a folder... the root folder does not have .csv in it, just the subfolders have csv files.
In some of the .csv, there are certain cells which are blank, but these blank cells show up when I view the file in openoffice, here is an example.
example.csv
Generally, each csv has only a few columns of data. For example..you can see cells A5:A9 dont seem to have content, but show up in the file as blank cells. This file only has one columns of data. I am looking for a macro which will go through and remove all these blaNk cells in all the subfolders of the main folder.
I appreciate any help you can provide..
thanks
Bookmarks