Hi:

I am importing text from two different HTML tables. Table One is Golf Scores
with the player Name and their position in the tournament. Table Two (from a
different website) is the World Golf Rankings, with the Player Name, and
their World Ranking.

I need to do Lookups in both tables using the name from Table One. When I do
a Lookup on Table Two using the name from Table One, it cannot locate it,
even though it is there.

A simple test seeing if the two seemingly identical text fields are "equal"
to each other, shows they are not.

Is tjhere some type of invisible formatting, or invisible characters that
are embedded in the text? And if so, is there a way to "normalize" the text?

Thanks!