Results 1 to 13 of 13

Organize large space delimited text file into appropriate rows and columns in excel.

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    7

    Organize large space delimited text file into appropriate rows and columns in excel.

    I have collected data into a large text file such that each value is space delimited. I would like to import this text file into Excel in order to analyze it better. I have pasted a portion of the text file into Excel in order to attach it to this ticket. Whether I copy and paste the data or import it, I don't care, just as long as I can organize it in Excel.

    I need the data to be organized into 5 different columns with the first value going into A1, the second value into B1, and continuing until the fifth value is in E1. Once there, it needs to repeat so that the sixth value is placed in A2, the seventh in B2 until the the tenth value is in E2.

    For example, if I had this series of data:
    0053 02A3 0000 0000 0000 0054 02A3 0000 0000 0000 0055 02A3 0000 0000 0000

    It would need to be organized like this, with each value in it's respective row and column:
    0053 02A3 0000 0000 0000
    0054 02A3 0000 0000 0000
    0055 02A3 0000 0000 0000

    I hope that makes sense, let me know if you need any clarification.
    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Space delimited text to multiple columns
    By mogdog1981 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-09-2010, 08:55 AM
  2. Import space delimited text file into excel
    By vijay2482 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2009, 12:29 PM
  3. Opening a space delimited text file in Excel
    By c_mei83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2009, 02:00 AM
  4. Replies: 3
    Last Post: 06-18-2005, 01:05 AM
  5. [SOLVED] Excel 2003 Importing large delimited text file
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2005, 11:06 AM

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