Greetings,
I am analyzing protein sequences, and wanted to use Excel's tools to facilitate the analysis. For that, I wish that all amino acids (1-letter abbreviation) occupies its own cell. The main problem is that the sequences come without any delimiter, and they can be quite long (hundreds if not a couple thousand characters).
I'm sure there is a way to split the 1 cell into 336 (example in front of me right now) cells, perhaps using VBA (with which I'm not familiar).
The example: Cell A1 has this string: MIINHNTSAINASRNNGINAANL
How can I make cells A2->... each include 1 character (here, a 23-character string becomes 23 cells of 1 character).
There would be many more sequences, much longer than this example here, so I'd love a way to automate this as I enter the sequences.
Thanks for the help!
I am analyzing protein sequences, and wanted to use Excel's tools to facilitate the analysis. For that, I wish that all amino acids (1-letter abbreviation) occupies its own cell. The main problem is that the sequences come without any delimiter, and they can be quite long (hundreds if not a couple thousand characters).
I'm sure there is a way to split the 1 cell into 336 (example in front of me right now) cells, perhaps using VBA (with which I'm not familiar).
The example: Cell A1 has this string: MIINHNTSAINASRNNGINAANL
How can I make cells A2->... each include 1 character (here, a 23-character string becomes 23 cells of 1 character).
There would be many more sequences, much longer than this example here, so I'd love a way to automate this as I enter the sequences.
Thanks for the help!