Thanks, Pete.

Now, can you help with this too?

COL A has 2,374 cells containing 9-character strings that look like
this:

102050013
102050016
110103030
116300004
161180034

COL B contains 4,800 cells containing up to 27-characters strings that
look like this:

102050001102050013
102050011102050016
106211018116040018116300004
110103012110103030
116040018116300004
161180032161180034
170212022170212025
174301015174301034174301040
174301017174301036174301041
174301034174301040
174301036174301041
174320014174320025
179221003179221008179221016

How do I search COL B for strings that match those in COL A?