Tag Archives: Cell values

Shorten contents of spreadsheet cells

I have a spreadsheet file with a list of species’ Latin names. I want to automatically create abbreviations for each species, by shortening both the genus and specific epithet to a certain number of characters. Here’s how to do it.

Posted in Academic, office | Tagged , , , , , | Leave a comment

Row to column in Gnumeric

I have some spreadsheet data which I want to present in columns, instead of the rows that I initially entered. I searched a bit and found instructions for Excel here. The principle is the same, so here’s what I did … Continue reading

Posted in Academic, office | Tagged , , , , , | 1 Comment

Cell values as rows in a spreadsheet

I have some spreadsheet data where the first column lists the position of a certain amino acid within a protein. There areĀ  many amino acid sites that are skipped, therefore the rows do not follow the actual, uninterrupted, amino acid … Continue reading

Posted in Academic | Tagged , , , | Leave a comment