Calculate differences between text cells?
Hi everyone!
I have several cells with characters (amino acid sequences), but let's simplify to this:
ABCDEF
ABADEF
ABCDEG
ABCDEF
I would like to compare all cells to the first cell and get the difference sort of like this:
ABCDEF: -
ABADEF: 1
ABCDEG: 1
ABCDEF: 0
Then I will calculate these changes to percentage, but that I know..
But how can I get the amount of one-letter substitutions for each cell?
Thanks!
|