+ Reply to Thread
Results 1 to 5 of 5

Parsing Text from One Column, Ten Rows into One Row, Mulitple Columns

  1. #1
    Registered User
    Join Date
    10-12-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Parsing Text from One Column, Ten Rows into One Row, Mulitple Columns

    I'm new here and don't really do much programming in Excel VBA, so go easy on me
    What I'm trying to accomplish is take a record spanning ten rows, but in one column and have each piece of data display as it own column.
    Attached is an example.
    If you notice, when you import the txt file into Excel, the address spans between A2-A6, if dumped into one column(Sheet 1).
    Sheet2 shows the fields with fixed columns, as best as I could get them without cutting off data
    Please advise
    Thanks in advance
    Attached Files Attached Files
    Last edited by bullsfan80; 10-12-2010 at 02:58 PM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Parsing Text from One Column, Ten Rows into One Row, Mulitple Columns

    Presumably you have multiple records like this. I think you need to provide more info about the logic. Will all the records be exactly the same - the same number of characters in the same place? Any code needs to be latch on to a pattern of some description.

  3. #3
    Registered User
    Join Date
    10-12-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Parsing Text from One Column, Ten Rows into One Row, Mulitple Columns

    StephenR,
    Thanks for the response.
    Sorry about that, but yes I do have multiple records like this, and the fields will follow the same pattern. The "dummy" record I sent contains the most of the info to be present for one record.

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Parsing Text from One Column, Ten Rows into One Row, Mulitple Columns

    Are they always 10 rows long and will they be separated by a space?

  5. #5
    Registered User
    Join Date
    10-12-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Parsing Text from One Column, Ten Rows into One Row, Mulitple Columns

    Yes, that's correct.
    The records wil always be ten rows long and separated by a fixed amount of space.
    Last edited by bullsfan80; 10-12-2010 at 03:57 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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