Spreadsheet cells’ contents lengthPosted: 2021-11-07 Filed under: office | Tags: gnumeric, spreadsheet Leave a comment
I need to compare a list of UniProt identifiers to a database of protein-protein interactions. All IDs in my list are 6 characters in length, while the database I am comparing to has many entries that are longer. I want to clean these up, since nothing from my list will match to them and I also want to speed searches by making the database smaller.
So, I searched a bit and found this discussion for Excel. In my case, I used the following formula to determine which cells have contents that exceed 6 characters:
Now I can just sort on column D.