How to save a specific range of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!)
 
Thanks,

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

STeve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
Save a Range on a Workbook as a CSV File 2
Excel How do I delete images in a specific range 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel CSV Files; Creating Of 3
VBA set thick borders around non empty cells in range 0
How to pick a specific cell within a macro .... ?? 4
Convertion of excel to CSV format 1

Back
Top