ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Text to columns (https://www.excelbanter.com/excel-worksheet-functions/83543-text-columns.html)

paulinoluciano

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


paulinoluciano

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