Part Matching Duplicate Values

hi,

hope someone can help. Desperately need to do part matching similar to this scenario:

ColA
there was a dog that jumped over
there was a dog that jumped over the fence

Everything is in ColA. We are on excel 2007. We need to highlight these two are duplicates based on matching the first 40 characters.

Please help!