Thanks:  0
Likes:  0

1. I want to break down a line of text(of amino acids from a protein) so only one character goes into each cell and the characters fill down a column. I'll give a simple example below, but often the line of text will be ~300 characters in length.

Starting with the following line of text ARNDCQE output should be.

A
R
N
D
C
Q
E

Is this possible? Thanks in advance.

2. i'd use text to columns (data menu)to separate the sequence letters into separate rows (fixed width option), then do a copy>paste special>transpose to change to columns.

3. Hi
Here's another way by formula:
Put this formula in A1 and scroll down
=MID(\$B\$1,ROW(),1)
Regards
Derek

4. Thanks to both of you.

I ran into problems with the text to columns in that I had to pick the size of each column it would be too time comsuming for a 300+ character text.

Derek, your formula worked Great!! Problem solved! Thanks a million..

5. On 2002-02-24 17:38, Derek wrote:
Hi
Here's another way by formula:
Put this formula in A1 and scroll down
=MID(\$B\$1,ROW(),1)
Regards
Derek
nice one, derek. your solution's also helped me out with something i've been trying to get right for a while.

6. Hi

=(MID(\$B\$1,ROW(),1))&A1

when you scroll this down it eventually reverses the original text in B1.
have fun
Derek

7. Here's what I was going to do, but of course you see my signature.

Put the ARNDCQE text into Word.

Select it all, but just the text, not the paragraph return at the end.

Hit ctrl-h (find/replace dialog) and put:

^? in the find what box and
^&^p in the replace with box

Hit Replace all.

Select it all, but only one paragraph return at the end.

Hit Table-Convert Text to Table. Tell it you want to use paragraph returns. Tell it you want one column. Ok.

Copy the new table into Excel.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•