First blank column removed in csv

[justforgroups]

Hi,
When saving an Excel file as tab-delimited .txt, all blank columns up to the first column with data, do not make it to the output. Is there a way of converting blank columns into tabs so they are written into the file? Thanks.

 

[tclark8]

I tried this and it worked for me (may not be the easiest solution though): in A1 put

=IF(B1=2,"","")

then copy across and down the empty cells. When I saved as csv it kept the empty spaces.