Fixed length text file

[Eric]

Is it possible to create a fixed length text file from an Excel file? Thanks!

[Nick Hodge]

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Eric" <Eric@discussions.microsoft.com> wrote in message
news:7446B0AD-0848-4D51-B999-C89CDF98BDAB@microsoft.com...
> Is it possible to create a fixed length text file from an Excel file?
> Thanks!