View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default text to columns - now paste does same

On Wed, 12 Sep 2007 21:53:35 -0500, Dave Peterson
wrote:

Try it again.

Put some test data into an empty cell
Select that cell
data|text to columns|delimited, but uncheck all the options
and finish up.

Clear that cell

Then try pasting your data.


Dave,

Your reply seems to confirm the suggestion from the first responent.
After spending some more time with the sptreadsheet I can't even
reproduce the original problem now.

I'll tuck this info away for a future day if I see the issue again.

Thanks for replying.


John Keith