Fixed length text file

  • Thread starter Thread starter Guest
  • Start date Start date
Eric

Set the columns to the character width of the fixed width column, e.g 30 for
30 characters. (even if the data is partly hidden or there seems a lot of
room in the cell)

Now save the file as a 'formatted text (Space Delimited)'. That should do it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

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

create fixed length cells & rows in excel as space delimited .prn 1
Excel Subtract text after the third space and before the fourth (from between spaces) 3
How do I autofill spaces in right justified fields? 1
Create an ASCII Fixed Length File from Excel 3
Fixed Length, Text Formatted 2
Excel-Export a file as a Fixed Length Text file 1
Filter on number of characters on a cell 3
Saving as fixed length file 1

Back
Top