Hi,

Being a relatively new commer to VBA, I am wondering if there is a
good way to go about comparing columns of text in Excel. Basically I
have a list of company names from one database and I am comparing it
to a list of company names from another database. My problem is that
the entry in one database will be slightly different from another.
For an example one of the lists might have: Frank's Welding Company,
but the other will have something like: Frank's Welding Company, LLC.
As a result the Vlookup command will not return very many results. Is
there an easier way to go about this than say checking letter by
letter while ignoring specifics like llc, the and others?

Furthermore to compound my problem, the list I am comparing it against
is some 4,000 entries long which means it will take forever to run
through the list entry by entry. I have played around a little bit
with Find, but I am not fimiliar enough with the command to use it
properly. In otherwords can I tell it to Find "Fr" at the start of an
entry and therfore skip to that section in the list?

Any help will be greatly appreciated.

Justin