Fixed Field Length in Excel

D

David

I am preparing an extract for BACS using Excel and want to format text and
numeric fields. If anyone is familiar with COBOL the mask would be PIC X(18)
so if the data is J Smith I want to see '...spaces...J Smith'. I will then
export to a text only file for onward tranmission.

I can define PIC 9(18) but not PIC X(18) and the resulting output field MUST
be padded with zeros or spaces respectively.

Any help gratefully received.
 

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

export excel to EBCDIC fixed-width text file 0
Excel export formatting problem for fixed width files 1
fixed length format file 3
create fixed length cells & rows in excel as space delimited .prn 1
Saving XL ranges as Fixed Field Length Text - Leading spaces 2
save an excel file in fixed length records whose fields are blank 1
import fixed-length text file into excel 4
Field length of VBA totals in Excel 2003 2

Top