How to Copy Formatted Text Data over excel rows

FabLeo 1 Posts Monday November 27, 2017Registration date November 27, 2017 Last seen - Nov 27, 2017 at 02:07 AM
Hello,

I need help with the following

I have Git formatted patches data in the Text file.(and there are N number of patches), which I need to copy to Excel in a Row such that Each Patch details should come into one cell.
(Manually We do it by pressing F2 and then paste, that way it also maintains the internal formatting )
I need to do it by means of Macro, since there are large numbers of patches.

Here is the quick Algorithm that I need to implement in the Excel Macro.
>>
; Here ### is the Delimiter(seperater) for Each Patch Data.

Algorithm:

Open text file;
Open eXcel sheet;

Loop
{
Copy Data till ### from text file;
press F2 in excel sheet ;
Paste Data(Maintaining internal formatting which can include special Characters, commas, Tabs,# signs);
move to next cell(next row);
Delete the copied Data and ### from Text file and repeat the loop ;
}

It would be of great help if you could help me with the same.

Thanks,
FabLao.
>>



See more 
1Posts Monday November 27, 2017Registration date November 27, 2017 Last seen