I have a text file with lines. All I want to do is convert line text into number. I want to declare them as array.and output them in different cells in worksheet.
Example:
if one of the text line is-
Text input:
C39000779710904010000053000000003100004000000000000002000000000000016
Excel output:
A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 P1 Q1 R1 S1
C 39 000779 7 1 09 04 01 00 00053 00000 00031 00004 00000 00000 00002 00000 00000 00016
(1 2 6 1 1 2 2 2 2 5 5 5 5 5 5 5 5 5 5) -> Length on the numbers
the text file has several lines. So there should be a loop to go through the end of file.
Please help me.
Bookmarks