I’ll say something about #1, but don’t have something to say about #2 right
now.



To strip apostrophes (or any character, you could use:

s = Replace(s, “’”, “”)

That’s taking a string  s, and replacing all apostrophes with nothing (a
zero-length string).



I suppose stripping out the apostrophes
is one way to go. If someone out there is a language expert, perhaps there’s
a more standard way of doing it, but it seems reasonable to me.



Also if you wanted to compare De Angelis and DeAngelis, you’d want to strip
out spaces, like:

s = Replace(s, “ “, “”)

Pictures in Excel VBA are in the Shapes collection. It's possible to loop
through each of the pictures  at a time selecting it but I'm not sure how to
return a range or row  to which they are anchored though.

The following line will return the Row of the top left cell for shape 1.

MsgBox ActiveSheet.Shapes(1).TopLeftCell.Row

, I'll be utilising both of your
pieces of advice. I look forward to interacting more and increasing
my skills.