Comparing and identifying cell contents

[plettieri]

I think my message got lost in the new site transition..so here it is a second time...sorry if i duplicated it.

I have imported into excel a list of formulars used in a different application. I wish to compare 2 cells (string text)items for this exercise and identify the differences.

EXAMPLE

A1:
DECODE(SUBSTR(Order No,1,1),'Z','Z-HOURS','3','WIP','0','WIP','J','WIP','P','WIP','T','WIP','2','5C1230','8','WIP','9','WIP','W','WIP',DECODE(SUBSTR(Order No,1,2),'W0','7808500'

Compared to:
A2
DECODE(SUBSTR(Order No,1,1),'Z','Z-HOURS','3','WIP','0','WIP','J','WIP','P','WIP','T','WIP','2','5C1230','8','WIP','9','WIP','W','WIP',DECODE(SUBSTR(Order No,1,2),'W0',


Difference Identified:

A3
'7808500'


I am looking to compare the first cell to the second cell and identify what differences there might be. Differences could be anywhere in the script.


I have about 100 cells to examine with about 800 characters in each cell.
It that possible and practical in excel - VB?


Tks in advance for looking at this

pll

 

[plettieri]

Tks Derek,

It must have taken a lot of time to put this together...I have a bit larger data size to look at...so i broke my data down into smaller bits and works great...

tks for looking...

pll