Convert text to columns
 

After pasting tesxt into an excel ss I choose convert test to columns in the
Data menu. This works well. However now anything I paste into the same
spreadsheet excel converts test to columns for all posted data

How do I stop this on subsequent pastes

Convert text to columns
 

Excel likes to help, you'll see that excel remembers those parsing rules the
next time you paste.

You can close and reopen excel (yech!).

You can put some dummy text into an empty cell
data|text to columns|delimited, uncheck everything
and finish up
and clean up that cell with the dummy text.

And excel will have forgotten how to help.

(Those are the only ways I know to stop this behavior.)


NWI wrote:

After pasting tesxt into an excel ss I choose convert test to columns in the
Data menu. This works well. However now anything I paste into the same
spreadsheet excel converts test to columns for all posted data

How do I stop this on subsequent pastes

--

Dave Peterson

Convert text to columns
 

I have tried the dummy text routine and it doesn't seem to work



"Dave Peterson" wrote:

Excel likes to help, you'll see that excel remembers those parsing rules the
next time you paste.

You can close and reopen excel (yech!).

You can put some dummy text into an empty cell
data|text to columns|delimited, uncheck everything
and finish up
and clean up that cell with the dummy text.

And excel will have forgotten how to help.

(Those are the only ways I know to stop this behavior.)


NWI wrote:

After pasting tesxt into an excel ss I choose convert test to columns in the
Data menu. This works well. However now anything I paste into the same
spreadsheet excel converts test to columns for all posted data

How do I stop this on subsequent pastes

--

Dave Peterson

Convert text to columns
 

Maybe you can document the steps you used.

It's always worked for me.

NWI wrote:

I have tried the dummy text routine and it doesn't seem to work

"Dave Peterson" wrote:

Excel likes to help, you'll see that excel remembers those parsing rules the
next time you paste.

You can close and reopen excel (yech!).

You can put some dummy text into an empty cell
data|text to columns|delimited, uncheck everything
and finish up
and clean up that cell with the dummy text.

And excel will have forgotten how to help.

(Those are the only ways I know to stop this behavior.)


NWI wrote:

After pasting tesxt into an excel ss I choose convert test to columns in the
Data menu. This works well. However now anything I paste into the same
spreadsheet excel converts test to columns for all posted data

How do I stop this on subsequent pastes

--

Dave Peterson


--

Dave Peterson