software

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,quot;no changequot;,quot;changequot;)

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

Andy wrote:
gt;
gt; Can Excel show the differences in text strings which appear in different cells
gt;
gt; eg changes of wording in similar phrases
gt; --
gt; Thank you very much
gt;
gt; Andy

--

Dave Peterson

Thankyou Dave for the solution

Ideally a solution would be found which could highlight the differences
between quot; the two catsquot; and quot;the three cats in the gardenquot; - excel would
highlight quot;threequot; and quot;in the gardenquot;

--
Thank you very much for your advice

Best Wishes

Andyquot;Andyquot; wrote:

gt; Can Excel show the differences in text strings which appear in different cells
gt;
gt; eg changes of wording in similar phrases
gt; --
gt; Thank you very much
gt;
gt; 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:
gt;
gt; Thankyou Dave for the solution
gt;
gt; Ideally a solution would be found which could highlight the differences
gt; between quot; the two catsquot; and quot;the three cats in the gardenquot; - excel would
gt; highlight quot;threequot; and quot;in the gardenquot;
gt;
gt; --
gt; Thank you very much for your advice
gt;
gt; Best Wishes
gt;
gt; Andy
gt;
gt; quot;Andyquot; wrote:
gt;
gt; gt; Can Excel show the differences in text strings which appear in different cells
gt; gt;
gt; gt; eg changes of wording in similar phrases
gt; gt; --
gt; gt; Thank you very much
gt; gt;
gt; gt; Andy

--

Dave Peterson