Saving as fixed length file

  • Thread starter Thread starter Tina W.
  • Start date Start date
T

Tina W.

If it can be done, can anyone tell me how to save an
Excel file as a fixed length text file?

Thanks,
Tina
 
You have a few choices (try against a copy of your worksheet):

I'd either concatenate the cell values into another column:

=LEFT(A1&REPT(" ",5),5) & LEFT(B1&REPT(" ",4),4) & TEXT(C1,"000,000.00")

(You'll have to modify it to match what you want.)

Then I'd copy and paste to notepad and save from there. Once I figured out that
ugly formula, I kept it and just unhide that column when I wanted to export the
data.

If that doesn't work for you, maybe you could do it with a macro.

Here's a link that provides a macro:
http://google.com/[email protected]
 

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
Fixed Length, Text Formatted 2
Excel-Export a file as a Fixed Length Text file 1
How do I save a 689 character fixed field/record format file 1
How do I autofill spaces in right justified fields? 1
Fixed length text file 1
fixed length file 2
Insert multiple .dat files into one pdf without losing color of their graphs 0

Back
Top