Then your entries don't really start with the letters "at" followed by a
space.
If you pasted the data from the web, the web designer may have used a
non-breaking space (CHR(160)) instead of a space character (CHR(32)). In
that case, either substitute the characters (perhaps using
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
) or change the 3 to 2 and correct the Atlanta entry for interleague
play, if any.
In article .com,
"paul" wrote:
This does not seem to work at it returns with "Rogers Centre" for all
examples.