ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Exporting Data (https://www.excelbanter.com/excel-worksheet-functions/19090-exporting-data.html)

Ket

Exporting Data
 
Dear All,

I have a perplexing issue!?

Is there any way that an export can be undertaken with excel whereby I
can specify a fixed width export?
Eg I want to be able to export my spreadsheet and specify that all the
columns need to be 50 characters big, therefore, if a cell contains
more than 50 characters, it will be truncated and if it is less than
50 characters, it is padded.

Any suggestions welcome.

Thanks in advance.

Regards,

Ket
London


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com