Spreadsheet cells’ contents length

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:

=if(len(B1)>6,"Yes","")

Like this:

Now I can just sort on column D.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s