Trim extraneous data?

[EndersG]

I imported a spreadsheet in Excel to an Access table but unfortunately brought those nasty control code characters (i.e., carriage return, line feed) in some of the column fields that look like hieroglyphics. Is there anyway to write an update query to remove those leading and trailing characters from the fields in the new Access table? I tried the Trim() function but it didn't do the trick. Any suggestions?