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.