![]() |
Text to columns
Hi,
I have a text file that is all like bellow: Sequence 1 ASASAKAKDHKDAMDKJADHKJHDADHAKJDHADJADJKADHAKJDHAD Sequence 2 HASGASGDASGADGDGASAHSHJ Sequence 3 HAGKDSHGADSKDAHJ ....... I can have 1000 or more sequences but the general structure is always this. Thus, I would like to use some kind of VBA code in order to open this file in Excel after line A2 in which I would have the name Sequence 1 and in B2 I would have the corresponding sequence(ASASAKAKDHKDAMDKJADHKJHDADHAKJDHADJADJKAD HAKJDHAD). This would have to be done for all the others in A3-B3, A4-B4.... Sequence 1 ASASAKAKDHKDAMDKJADHKJHDADHAKJDHADJADJKADHAKJDHAD Sequence 2 HASGASGDASGADGDGASAHSHJ Sequence 3 HAGKDSHGADSKDAHJ ..... Thanks in advance, Luciano |
Text to columns
-
|
All times are GMT +1. The time now is 04:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com