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

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

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

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

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