I am trying to join SHP by field CONCATENATE with my XLS sheet. SHP attributes looks like this:
Because of those slashes in ID fields, I choose to TEXT type for field CONCATENATE.
When I open DBF file (from that shp) in Excel, I add a field MATH, where I will calculate, then save it as XLS.
To problem is that when I try to join my SHP by field CONCATENATE with XLS sheet by field CONCATENATE ArcMap can't offer it.