I have a table with data based on intersections of a cities general plan, zoning, and parcel data. I exported the resulting information into a table and cleaned it up in Excel. Now I want to bring it back into ArcMap and table join this data back into a clean parcels feature class using the APN numbers. The problem I am having is that the APN column includes a string of 8 numbers AND letters which, when brought into Arcmap, leaves the number-letter APN's as NULL.
Likely, this is because bringing this table back into Arcmap makes the column LONG when it should be TEXT to maintain the format of number-letter for purposes of table joining.
I can not, for the life of me, get the 'text' cell format in excel to stick when I bring it back into ArcMap. It always changes it to LONG which then results in NULL values.
I have even tried to save it as .txt rather than .csv and this still happened.