Calculate differences between text cells?

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate differences between text cells?

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-17-2012, 03:51 AM

poobear

Calculate differences between text cells?

Mac OS X

Office for Mac 2011

Novice

Join Date: May 2011

Posts: 6

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!

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wraping merged cells text - the text dissapears	shabbaranks	Excel	1	03-02-2012 02:35 AM
Combining Text from Table Cells	robmorleyuk	Word	1	11-01-2011 07:24 AM
Question regarding differences among styles	bigsnowdog	Word	0	08-01-2010 02:41 PM
Cells with wrap text not showing text	lazylew	Excel	1	08-31-2008 06:58 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 AM.