I am importing a text file into a sheet. The file imports with each line being one cell.
I need to break up the contents of the cell based on the character at the beginning of the line based on the first character of the line. I would like to have it put in the cells next to the line split up as follows
All lines beginning with "A"
1 9 10 4 6 5 1 6 11 52 <--Numbers are the positions in the field, EG A0000000019172400220514201005300220D000396
Becomes
A 000000001 9172400220 5142 010053 00220 D 000396
All lines beginning with a "Y:
1 15 30 3 5 12 39
All lines beginning with "C":
1 3 10 6 3 5 12 30 19 15 1
All lines beginning with "D":
1 3 10 6 1 3 5 12 30 19 15
All lines beginning with a "Z":
1 9 10 4 14 8 14 8 37
What do you think?
I just really need a hand with one of them and I can figure out the remainder from that.
Thanks,
D
Bookmarks