Remove unprintable charactars

  • Thread starter Thread starter DaveMoore
  • Start date Start date
D

DaveMoore

I regularly create text files from our accounting package, Dynamics (now a
microsoft package I believe).

In doing so, numbers appear with a prefix character ( like an L the wrong
way round) that will not print. Is there a function or formula, like TRIM
that removes superfluous spaces, that will remove these? I am currently
getting over the problem by Text to Columns, Fixed Width, and not importing
the first character. But this too can cause problems when there is a -
present.

Any help will be appreciated

TIA
Dave Moore
 
Just in case...

try CLEAN function that removes non-printable characters
(as per definition of the function).
 
Back
Top