Text comparison in adjacent cells

A

Andy

Can Excel show the differences in text strings which appear in different cells

eg changes of wording in similar phrases
 
D

Dave Peterson

It can show that there is a difference pretty easily:

=if(a1=b1,"no change","change")

But it would pretty impressive to be able to parse those values and show the
differences (whatever that means).
 
A

Andy

Thankyou Dave for the solution

Ideally a solution would be found which could highlight the differences
between " the two cats" and "the three cats in the garden" - excel would
highlight "three" and "in the garden"

--
Thank you very much for your advice

Best Wishes

Andy
 
D

Dave Peterson

I'm not sure this helps, but MSWord has that kind of comparison. Maybe you
could copy the cells in each worksheet range to separate documents and use
Tools|Compare and merge documents (In MSWord).
 
Top