Symbology is creating delimited values, potentially embedded?

Discussion created by coilx005 on Jun 8, 2014
Latest reply on Jun 14, 2014 by coilx005
I am performing the simple task of creating shapefiles from XY tables using some Excel spreadsheets and am having problems with the symbology. Each time I try to classify using unique values, I get a set of delimited values that are not in the Excel file and they are not showing up in the attribute tables. I have manually re-typed the entire Excel file and have had the same problem. The first column has commas within the text file, so I tried deleting the commas (and the column completely at one point) and the same problem persists. I had no problems with one sheet from the same file, but this specific sheet has me baffled.

Does anyone know how to rectify this problem or any possible solutions I could try?  I have attached a screen shot to show what is happening.