Re: [Clip] Re: clip to convert excel files to set width text files
- Sheri wrote:
> --- In email@example.com, "Don - HtmlFixIt.com" <don@...> wrote:Sigh and I thought I read them all carefully. I have never heard of a
>> Am I missing some export
>> or save as that I should just be using from excel to do it?
> I think Save As Formatted Text (space delimited) (*.prn) is what
> you're looking for. You will need to include a header record with
> enough characters (including the desired spaces) in it, or the longest
> fields won't be separated from their next columns.
prn file before, but it did what it should even without a header record.
Gosh you never cease to amaze me!