# Spreadsheet to take a substring of any RNA sequence

**URL:** https://forum.eternagame.org/t/spreadsheet-to-take-a-substring-of-any-rna-sequence/4310
**Category:** Tools
**Created:** [September 19, 2022, 10:19pm UTC](https://forum.eternagame.org/t/spreadsheet-to-take-a-substring-of-any-rna-sequence/4310 "2022-09-19T22:19:33Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![lroppy](https://forum.eternagame.org/letter_avatar_proxy/v4/letter/l/8baadc/32.png) [@lroppy](https://forum.eternagame.org/u/lroppy)
#### Post date: [September 19, 2022, 10:19pm UTC](https://forum.eternagame.org/t/spreadsheet-to-take-a-substring-of-any-rna-sequence/4310/1 "2022-09-19T22:19:33Z")

</div>

Follow this link to a downoladable spreadsheet to allow you to take a substring of any RNA sequence. (Download is under the “File” Menu…)

[Get a Substring of an RNA Sequence](https://docs.google.com/spreadsheets/d/1SzQjZfEojdbGM7DziIsbFTXs5D4YYfWr/edit?usp=sharing&ouid=113100682970677507721&rtpof=true&sd=true)

---

<div class="post-metadata">

### Author: ![DigitalEmbrace](https://forum.eternagame.org/user_avatar/forum.eternagame.org/digitalembrace/32/4445_2.png) [@DigitalEmbrace](https://forum.eternagame.org/u/DigitalEmbrace)
#### Post date: [September 25, 2022, 2:46pm UTC](https://forum.eternagame.org/t/spreadsheet-to-take-a-substring-of-any-rna-sequence/4310/2 "2022-09-25T14:46:24Z")

</div>

Very handy tool. To access the sequence output, I clicked on the formula line.

 ![Screen Shot 2022-09-25 at 7.43.51 AM](https://d2he8ud106d9gn.cloudfront.net/original/2X/3/3d174b11d5f2cfcf13dc5987de8fb8562023b6ee.png)

---

<div class="post-metadata">

### Author: ![DigitalEmbrace](https://forum.eternagame.org/user_avatar/forum.eternagame.org/digitalembrace/32/4445_2.png) [@DigitalEmbrace](https://forum.eternagame.org/u/DigitalEmbrace)
#### Post date: [June 10, 2023, 1:31pm UTC](https://forum.eternagame.org/t/spreadsheet-to-take-a-substring-of-any-rna-sequence/4310/3 "2023-06-10T13:31:33Z")

</div>

Bumping this post in case anyone needs to isolate part of a long sequence for Pseudoknot Detective. If a player is looking at a large structure in RNACentral, for example, and spots a possible pseudoknot, the sequence can be copied into this spreadsheet and snipped at desired base positions.