Don

If all Excel files affected, it is possible you have ToolsOptionsTransition
"Transition Navigation Keys" enabled.

Gord Dibben Excel MVP

On Mon, 20 Dec 2004 18:03:02 -0800, Don wrote:

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