Hi,

In A1, we have the text "acdir" (without quotes) and in B1 we have the text
"acdirtyu" (without quotes). In cell C1 enter the following array formula
(Ctrl+Shift+Enter)

=IF(ISNUMBER(FIND(A1,B1)),MID(B1,COUNTA(MID($A$1,R OW(INDIRECT("1:"&LEN(A1))),1))+1,10))

Please check various combinations to see how it works. If you have any
further queries, please feel free to contact me at .

Regards,

Ashish Mathur

"Kelli Freeman" wrote:

In Excel XP I'm trying to compare two columns and extract the differences in
the 3rd column. For example,

Column 1 Column 2 Column 3
ACD ACDI I

Is it possible to perform this function?