Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Amino Acid sequence

  1. #1
    Guest

    Default

    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. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Guest

    Default

    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. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    ~Anne Troy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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