I have data that consist of several pages, each line will load into an excel single cell, however each line has 15 or more pieces of information that has to be extracted to a single cell.
Is there a simple VB code to do this? Each info piece is separated by a space.
I am using MO 2013 on Windows 7
an example line in Cell A1;
04/15 06/15 14021 GAS R M 0.00427652 2.60 6.60 SEV6 0.34 6.26 06/29/15 1093385 1745
04/15 should extract to cell B1
06/15 should extract to cel C1
etc through P1
Then the code should loop to repeat for line 2 which is in cell A2, extracting to row 2
until encountering a blank row then end
Bookmarks