It can be hard to notice where two strings are different in the Apps Script logger. We can borrow JsDiff to help with that.
I'll be using the cjsDiff library
You can report on any combination of additions, deletions or no changes. This example does them all.
And the result
If that doesn't quite do it for you, There are various options you can use as documented here
For more like this, see Google Apps Scripts snippets. Why not join our forum, follow the blog or follow me on twitter to ensure you get updates when they are available.
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Google Apps Scripts snippets >