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



Andy wrote:

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

"Andy" wrote:

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

eg changes of wording in similar phrases
--
Thank you very much

Andy

--

Dave Peterson