Trailing Commas

[dedelkoo]

Good Morning All;

I'm hoping someone can help me with a formula that's adding a bunch of trailing commas to CSV files. Currently the formula reads:

=IF(ISBLANK(Parameters!A23),"",Parameters!A23)

The purpose is to draw in the value of cell A23 if in fact a value exists, if not the formula's result should be a blank cell. However when converting the file into CSV the "" registers as data, as such there are comma's at the end of each line with blank data.

Is there away to alter the formula above so that if Parameters!A23 is blank the result of the formula is a completely blank cell that would not be caught in a CSV file?

All thoughts are appreciated,

Derek

 

[WaterGypsy]

As you are dealing with column A - the first column then you must have a comma to indicate the presence of the cell - otherwise data in column B will land in A when you load the csv into excel.

Oooppsss I misread something ..... ignore my comment

 

[dedelkoo]

Thanks for the quick reply; I should have explained a bit better: the result of this fomula will be turned into a CSV file for upload into another program, not turned from a CSV into an excel sheet. The problem we're experiencing now is that the CSV file looks something like:

Betty, controller,
Tom, account manager,
Steve, admin,
, , ,
, , ,
, , ,
, , ,

Where the last three lines are the result of formuale that return a "" value in my formula above. I'm hoping there's a way that the formulae return a value that the CSV would completely ignore so that the CSV file would not have the last 4 lines above.

Betty, controller,
Tom, account manager,
Steve, admin,

For example.

Derek

 

[WaterGypsy]

I don't think that is possible... I'm pretty sure you will get a line regardless because Excel is probably processing each cell in turn and recognising that there are later cells it has to put out the delimiter as a place marker.

Your best bet might be to have a macro for the save process and in that macro delete any blank lines

 

[dedelkoo]

That's what I was affraid of, thanks for the input. I'll start crafting the clean-up macro.

Thanks again,

Derek