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
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