AnsweredAssumed Answered

Joining data does not work unless I retype the data in Excel

Question asked by HoChunk on Mar 21, 2018
Latest reply on Mar 21, 2018 by Dan_Patterson

I am joining data from a .txt file to a county shapefile. When I validate the join, it shows no matches. I found that if I retype a County Name in Excel that it will join that one record. So to fix my issue, I have been retyping every single county name and then joining that new txt file in ArcMap. This is fine for right now, but I would like to know how to quickly resolve this issue in ArcMap or Excel so I can stop manually typing the county names again. I have tried Copy and Pasting and many other ways to quickly duplicate the whole Field. Any Ideas?