I want to clean up some data that's having trouble importing into Arc. I want to know a way to clear spaces in only the top row in excel. Sometimes there is one hidden before or after the row name and it causes Arc to import them incorrectly. It will return an invalid SQL statement when it tries to draw in Arc. I'm using ArcGIS 10.2.2.
You can use the Replace function detailed in this guide:
Remove all spaces with the Replace function
Sometimes, we want to remove all spaces between character and numbers in a range, we can use Replace function to solve it.
Highlight the range that you want to remove all spaces.
Click Home > Find & Select > Replace…, the Find and Replace dialog box will pop out.
In the Find what box, press the space bar once, don’t input anything in the Replace with box, then click Replace All. There will be a prompt message telling you how many spaces have been removed. See screenshot: