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!!![]()
Hi and welcome to the board
Is there a reason why you posted an XL question in an Outlook Forum?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Most likely because I was taking and typing at the same time and was not paying attention!! Sorry about that :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks