Table Join Resulting in Null values (Picture Included)

Discussion created by samantham on Oct 20, 2012
Latest reply on Oct 21, 2012 by samantham
I have a shapefile of subdivisions. There is a separate excel file that contains the average year built for the subdivision. I am attempting to join them based on their common attribute, the subdivision name.

The problem is once I do so, it results in null values. I thought it was perhaps because the shapefile had the string stored in caps, and in excel it was in proper form. I converted the excel column into caps lock as well and still no luck.