I work in television and one of the pieces of equipment I'm responsibile for is called a 'stillstore', which I'll refer to as SS.
The SS has a database capable of storing 10,000 images, each with a unique number (from .0000 to .9999) and a description for each. The only method the SS has for exporting database info is for a Generic/Text printer to be setup on the PC, then print to this, specifying the filename, such as "stills.txt".
So far, so good......
When I import this into Excel, the result is all in Column A:
....and so on for thousands of rows.
Here's what I want to do:
I want to massage everything in this single column, so the info ends up in two columns:
.....and so on.
What I'm trying to do is break the data into two columns:
- in the original import, cells A1, A3, A5...etc are all Column A and renumbered to A1, A2, A3...etc.
- then cells A2, A4, A6...etc become Column B and are renumbed B1, B2, B3...etc.
Thoughts?
I've tried massaging this manually but I go blind after a very short time![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
The SS has a database capable of storing 10,000 images, each with a unique number (from .0000 to .9999) and a description for each. The only method the SS has for exporting database info is for a Generic/Text printer to be setup on the PC, then print to this, specifying the filename, such as "stills.txt".
So far, so good......
When I import this into Excel, the result is all in Column A:
Code:
A1 .0000
A2 Description of .0000
A3 .0001
A4 Description of .0001
A5 .0002
A6 Description of .0002
Here's what I want to do:
I want to massage everything in this single column, so the info ends up in two columns:
Code:
COLUMN A COLUMN B
A1 .0000 Description of .0000
A2 .0001 Description of .0001
A3 .0002 Description of .0002
What I'm trying to do is break the data into two columns:
- in the original import, cells A1, A3, A5...etc are all Column A and renumbered to A1, A2, A3...etc.
- then cells A2, A4, A6...etc become Column B and are renumbed B1, B2, B3...etc.
Thoughts?
I've tried massaging this manually but I go blind after a very short time