Text to columns

P

paulinoluciano

Hi,
I have a text file that is all like bellow:
Sequence 1 ASASAKAKDHKDAMDKJADHKJHDADHAKJDHADJADJKADHAKJDHAD
Sequence 2 HASGASGDASGADGDGASAHSHJ
Sequence 3
Click to expand...
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(ASASAKAKDHKDAMDKJADHKJHDADHAKJDHADJADJKADHAKJDHAD). 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vertical to horizontal repeat after 16 rows 3
Text manipulation 5
Subsequence of characters 5
Palindromes 3
A string of data in a cell 3
Need help with formula to count the number of times each date appe 3
assign a number to the same date & start over with 1 on new date 3
I need to indicate a missing # in a series 1

Top