Results 1 to 3 of 3

Extracting partial cell data to another cell

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2011
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Extracting partial cell data to another cell

    I have tried to search this, maybe I wasn't searching the correct syntax.
    What I am trying to accomplish is this:

    I had to copy data from a text file that has 926 lines of the same format:
    Example:
    AAAAAAxxxYYYYYYYYYYYYzz
    When I pasted this in to Excel, it inherently put all of this in the same cell.

    What I need to happen is that the following-

    AAAAAA goes into one cell, xxx goes in the following column, same row, YYYYYYYYYYYY, in the following and so on.

    I have attached a sample spreadsheet.

    Thank you in advance for any help!!
    Attached Files Attached Files

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