ArcMap Join Validation Error Help

[rajujee]

Hi, 

I am getting consistent error on joining 46k records from Arcmap Feature to CSV.

Field names containing invalid characters ' ' (screenshot attached for complete error)

I have done following but not luck

1. removed spaces in Excel (do i remove space in arcmap column)

2. checked text format (changed original data format in excel to text and default format didn't help)

3. removed few columns

I am joining on Location_Final Column. 

Owner ID

Address

City

Telephone

Location_Final

0001117	31 King Street , 111th Floor	Mycity, AD	9055461111	Sec-1 Row-2 Aisle-64
0001218	31 King Street East, 113th Floor	Mycity, AD	9055460000	Sec-1 Row-2 Aisle-65

[DanPatterson]

convert the csv to a geodatabase table since there are some efforts made to try to cleanup such data.  Then retry the join

[rajujee]

Thanks Dan. I have text field to join/connect/ It doesn't fix. Any other help!

[Darrin-Smith]

Research removing hex characters in Excel.  These would be characters you cannot see that will definitely cause join to fail.

[rajujee]

Thanks Darrin. I don't find any Hex characters. Other thoughts?