Excel empty cell contains values

I am working on a small ETL task trying to extracting data from a workbook. Some cells do not seem to contain any values but ISBLANK() shows false.
After some research, I found out if you put =”” into the cell, it will not display anything but it’s not blank. This could be very misleading when in extracting data from workbooks. The best way is to save the excel file as a csv file and launch the notepad apps to replace “ ,” with “,” to remove any spaces in between commas because the space in the cell was shown as a space in csv.