I have done the reading of the char. and spaces and while joining it STILL is fill with <NullLs
HELP please
I am having a similar problem. Under my waypoints field the values containing both alpha and numeric characters show up as null in arcmap. I have tried just about everything in formatting and I am at my wits end. Help me. I have attached the problem file as well as highlighted the waypoints which are reading as null in arcmap
Your spreadsheet is the problem. You've got mixed and matched formats in the same column. Some are true numeric, while others should be treated as text (those with Alpha characters imbedded). I suggest you create a personal geodatabase, and create a table with the following fields: XCoord(double), YCoord(double), Waypoint(text). Load your excel data into that and go to work.
I've had a similar problem as Grady Morrison. A .xlsx file containing text strings with spaces imports as <null>. I converted the file to .csv and ArcMap imported the strings including spaces without a problem. I'm not sure why that works, but it did work for me.