Removing special Characters.

[jeff p]

In my workbook, a sheet containing text/numerical information is exported as .txt files, using the code below.
The blank row in between each grouping is the separator.

ie: The example below would give me 3 txt files with the Title as the file name.

Title_01_001
This is text?
This is more, text.

Title_01_002
This, is text.
This is more text.
Additional text?

Title_01_003
This is more text.


The code below works fine, until I encounter these dreaded hidden characters from my original CSV file which i import into my worksheet, re order, then export as .txt
Regardless of the format i save the CSV,, UTF-8, or Comma delimited, I cant get rid of them upon re import.

These are a sample of the the special characters i encounter:

You don’t want to hear it? ( the apostrophe in the word "don't" is actually hidden in my workbook)
You don�t want to hear it?

How can I get rid of these? I've tried using =CLEAN(A1), along with various other work around. but it removes the "?" (question marks) along with other characters in my document.

Or better yet, is it possible to modify the code below to not error when it encounters them?
I just uploaded a simple file, if this will help.

Thanks for any help on this.
Jeff

[ByteMarks]

How do you import the csv file?

[jindon]

Try

Please Login or Register  to view this content.

[jeff p]

Thanks, Jindon
.. but doesn't seem to work.



Thanks, ByteMarks

Here's how I'm importing the file.
Unicode (UTF-8). using comma as the delimiter

[jindon]

Thanks, Jindon
.. but doesn't seem to work.

Working here...
Here's a sample to import UTF-8, so see if this outputs correctly...

Please Login or Register  to view this content.

[jeff p]

Thanks for the help, Jindon.

Tried to import the file, The special characters are now gone, .. but the delimiter separation isn't accurate.

...Either way, Ive solved my own problem.
The special characters were created by the initial CSV export.
Once that was corrected, everything seems to be working well.

Thanks again..
Jeff