How to save Excel file to csv with blank cells with formula with out getting commas.

Originally Posted by xizor

Thank you for your reply. I am currently trying to do you have suggested, copying and pasting special |values to a blank sheet then opening the .csv with not pad and it is still showing with ",,,," inside the .csv file down the file.
I have double checked the cells to make sure there are no formula's in them. I have tried to special past the values in a completely new work book but i still get the same results?

I much appreciate the assistance!

Regards,
Xizor

Any other suggestion from anyone?