+ Reply to Thread
Results 1 to 3 of 3

Fixed Length File - ASCII Format

  1. #1
    Registered User
    Join Date
    03-03-2014
    Location
    Alabama
    MS-Off Ver
    Excel 2013
    Posts
    10

    Fixed Length File - ASCII Format

    Hello,

    I need to transfer a data file I have created in excel to another program. I'm required to transfer the file with a 80 byte record length in the ASCII format. I only have data the following positions: 1-15 and 42-48. Positions 16-41 and 49-80 must be left blank. How can I save the file with a 80 byte record length leaving positions 16-41 & 49-80 blank, then copy/paste into Notepad? The records should be delimited with a CR/LF combination. I've attached a sample of my data: test 2.xlsx

    Thank you very much for your help

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Fixed Length File - ASCII Format

    Using your posted workbook...Off to the right create this formula and copy it down as far as you need.
    Please Login or Register  to view this content.
    Those formulas create fixed width text (80 chars)

    Copy the formula cells and paste into notepad.
    Save the notepad file.
    Done

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    03-03-2014
    Location
    Alabama
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Fixed Length File - ASCII Format

    That works! Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import Fixed Length File
    By tandrews in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2007, 12:19 PM
  2. Fixed length text file
    By Eric in forum Excel General
    Replies: 1
    Last Post: 07-12-2006, 05:05 PM
  3. [SOLVED] Fixed length file import??
    By Trey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2006, 04:50 PM
  4. [SOLVED] Exporting from Excel to a Fixed Length Flat File
    By Markus L in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  5. [SOLVED] Saving an EXCEL spreadsheet in fixed length format
    By PrakashK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1