Hi,

I am trying to use a VLOOKUP on a list of locations. In one list I have the
name, in the other it is the name with a space at the end. For example:

List one: SOUTHAMPTON
List two: SOUTHAMPTON_

List two is from a system so I cannot stop it putting a space at the end,
and it is this list that I need to VLOOKUP from.

How do I get the VLOOKUP to ignore the space on the end? (The locations are
various lengths and may have two words with a genuine space in the middle).

Hope this makes sense.

Thanks

Amanda