0 - 1 of 1 tags for whitespace

We recently had a situation where some rows of data contained trailing spaces ie. 'ABC123    ', when we did a trim on the field it didn't remove the trailing space as was expected.  The source data was loaded from an Excel spreadsheet into a TD table.  To be exact it was 4 spaces.