This question did NOT provide an answer that worked; I erroneously awarded points. It seemed to work but did not; the saved tab delimited sheet still has the issue.
I'm thinking that the character should be 013, not 010.
I also tried the Macro suggested as the last comment; does not work.
An Access person wanted me to zip & post the Access database from whence the Excel came; I cannot do that, the database contains sensitive company information.
Any ideas, either in an Access query or in Excel on how to remove carriage returns from fields will be appreciated.
Can't I just remove the carriage return stuff in an Access Query?