I have to save a specific range of data, including 1 empty cell on each row
in CSV format. This is to create an extra comma on the end of each record.
I have not been able to figure this out and would appreciate any help.

try putting something in that cell.

I'd use =""
It looks empty, but the formula reminds me why it's there.

But you could use an apostrophe (and maybe just a spacebar--I didn't test that
one!)

Steve wrote:

I have to save a specific range of data, including 1 empty cell on each row
in CSV format. This is to create an extra comma on the end of each record.
I have not been able to figure this out and would appreciate any help.

--

Dave Peterson

Thanks,

That works, but I also found that a single apostrpohe works as well. Thanks
for pointing me in the right direction

STeve

"Dave Peterson" wrote:

try putting something in that cell.

I'd use =""
It looks empty, but the formula reminds me why it's there.

But you could use an apostrophe (and maybe just a spacebar--I didn't test that
one!)

Steve wrote:

I have to save a specific range of data, including 1 empty cell on each row
in CSV format. This is to create an extra comma on the end of each record.
I have not been able to figure this out and would appreciate any help.

--

Dave Peterson