I just wanted to ask this for future reference, is there a good reliable way to check for white space in excel spreadsheets and such you receive from others?

Three or four times now I've had problems performing joins because of this, I just wanted to know if there is a good consistent way to check for it.

closed as off-topic by PolyGeo Aug 18 '16 at 22:29

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions relating to general Information Technology, with no clear GIS component, are off-topic here, but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software) and Database Administrators (relational databases)" – PolyGeo
If this question can be reworded to fit the rules in the help center, please edit the question.


Use TRIM in excel,

Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.


TRIM(text) You only really need it on the join field.

Not the answer you're looking for? Browse other questions tagged or ask your own question.