+ Reply to Thread
Results 1 to 7 of 7

Correct word wrap issues in data imported from a text file

  1. #1
    Registered User
    Join Date
    11-12-2007
    Location
    Virginia
    Posts
    19

    Correct word wrap issues in data imported from a text file

    I am trying to come up with an easy way to edit the results of a text file import which wraps the description column (B) thus generating a new row in the sheet. The perfect function would look for a blank in column A, add the data in column B to the data in column B above it, then delete the row with the blank A. It would also have to account for the fact that some of the wraps generate multiple rows (line 46, 56 and 59 of the attached sample). The complete import is in excess of 5k rows so doing all this manually is not very pleasant. Any help is (as always) GREATLY appreciated!
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Try this:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-12-2007
    Location
    Virginia
    Posts
    19
    Worked fine for the first 2400 rows then stopped. Tried running again but no results. Any suggestions?

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Got a blank in column B?

  5. #5
    Registered User
    Join Date
    11-12-2007
    Location
    Virginia
    Posts
    19
    No blanks in B all the way to the end of the file.

  6. #6
    Registered User
    Join Date
    11-12-2007
    Location
    Virginia
    Posts
    19

    Problem Solved!! You guys ROCK!!!

    Took the problem home over the weekend and ran it through my computer which handled the complete file with no hiccups. Guess my work computer just isn't up to the task.

  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    We are all pleased to have been of service ...

+ 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