Extracting partial cell data to another cell

[radiowhacker]

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!!

[arthurbr]

Hi and welcome to the board

Is there a reason why you posted an XL question in an Outlook Forum?

[radiowhacker]

Most likely because I was taking and typing at the same time and was not paying attention!! Sorry about that :-)