Hello everyone, I'm not sure if anyone can help me with my problem, but I thought I would at least toss it out there. I'm attempting to break out different data types from a single field that was used for comments. Cell A1 contains a box...
Hello everyone,
I'm not sure if anyone can help me with my problem, but I thought I would at least toss it out there. I'm attempting to break out different data types from a single field that was used for comments. Cell A1 contains a box number. Cell A2 contains the data that I need to break out.
Within the data cell the data types needing to be broken out are.
Dates end with a :
Agency ends with a ;
Documents end with a ,
Comments are contained in ( )
The trick is that for every Document the Box Number, Date, Agency and Comments are duplicated.
Example of current data:
(A1)
1. 075-04-0591-0202-0286
(A2)
1. OCT 1994-MAR 1995: K00; STATEMENT OF DIFFERENCES, STATEMENT OF TRANS, DISTRIBUTION REPORTS, SCHEDULE OF CD'S, GENERAL LEDGER ACCOUNTS (DOC TYPE NOT IN BOX)
What I'm trying to do:
(A3) Box Number
1. 075-04-0591-0202-0286
2. 075-04-0591-0202-0286
3. 075-04-0591-0202-0286
4. 075-04-0591-0202-0286
5. 075-04-0591-0202-0286
(A4) Dates
1. OCT 1994-MAR 1995
2. OCT 1994-MAR 1995
3. OCT 1994-MAR 1995
4. OCT 1994-MAR 1995
5. OCT 1994-MAR 1995
(A5) Agency
1. K00
2. K00
3. K00
4. K00
5. K00
(A6) Documents
1. STATEMENT OF DIFFERENCES
2. STATEMENT OF TRANS
3. DISTRIBUTION REPORTS
4. SCHEDULE OF CD'S
5. GENERAL LEDGER ACCOUNTS
(A7) Comments
1. DOC TYPE NOT IN BOX
2. DOC TYPE NOT IN BOX
3. DOC TYPE NOT IN BOX
4. DOC TYPE NOT IN BOX
5. DOC TYPE NOT IN BOX
If anyone can help it would be greatly appreciated. Thanks in advance!
Linear Mode
