How to save a specific range of data
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 |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com