Unfortunately, this has no effect on the column (or row, depending on which
is selected). To clarify:

Cell A1 is: 'Field1

By selecting Data / Text to Columns / Finish, nothing changes.

Nor does the content of the cell(s) change when selecting a different Text
Qualifier (changing from the default " to ').

Any other ideas? These characters are a result of exporting from Access to
Excel. Very annoying. As mentioned, I also have them in other Excel files,
and simply want to remove them all.

"Ragdyer" wrote:

TTC - Text To Columns!

Select the data, then simply open and close TTC.

Select the data (in a single row),
<Data <TextToColumns <Finish