Amino Acid sequence

G

Guest

Guest
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.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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.
 
Upvote 0
Hi
Here's another way by formula:
Put your sequence in B1
Put this formula in A1 and scroll down
=MID($B$1,ROW(),1)
Regards
Derek
 
Upvote 0
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..
 
Upvote 0
On 2002-02-24 17:38, Derek wrote:
Hi
Here's another way by formula:
Put your sequence in B1
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.
 
Upvote 0
Hi
Another interesting thing about this formula is that if in A2 you add &A1 to the formula

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

when you scroll this down it eventually reverses the original text in B1.
have fun
Derek
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top