Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing a string as columns.
Using a data connection, I get the following string:
52014,1868,61691259 133878,88,4544190 93464,88,4466101 194208,89,4851141 164320,89,4972916 234386,80,2033390 119520,70,756142 196767,82,2477652 102349,89,5179496 138197,86,3669161 186012,85,3352716 224651,77,1599646 7666,99,13271321 53994,76,1385884 88911,71,828589 94489,77,1483429 72524,67,580513 25455,75,1215975 62641,71,830699 90562,75,1231729 65625,68,607909 31582,73,999948 180230,64,433406 96940,61,305742 64779,68,613564 -1,-1 -1,-1 -1,-1 -1,-1. At the moment I extract 90 such strings and have written a macro to separate each string into columns. Having it done as I open the sheet would make it so much easier for me. Is there a way to display the string as columns directly from the download without going through 'text to columns, select delimiter, do not download column'? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing a string as columns. | Excel Programming | |||
Importing a string as columns. | Excel Programming | |||
number as string with importing txt file | Excel Discussion (Misc queries) | |||
Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
Importing Long String - String Manipulation (EDI EANCOM 96a) | Excel Programming |