I am attempting to import the attached excel file into ArcMap so that I can use the table's address fields in order to geocode the field locations in order to create a shapefile of this data. When I import this file in, I get the heading field to load fine, but all the attribute data in the fields is <Null>. Is this a excel formatting issue that I cannot seem to locate? Or am I going about this in an incorrect manor?
Thank you for your time, and any help is great appreciated!
Use the TRIM function. In a new column click on the first cell and click on the Insert Function button in the formula bar (fx). Enter TRIM in the search field and select TRIM from the results. Then enter the cell reference or choose the cell selector (grid looking tool to the right of the argument entry box). Then click OK. You can copy and paste that formula to the rest of the cells in that column. But I think you will then have to select the entire contents of that column you just created and copy it. Then go to the next empty column at the top and right click then select "Paste Special" and select "Values" from the choices. Then you can delete the column with the formula in it and what you have left is a column with the trimmed text values. ArcMap probably won't handle a formula in a cell.