View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default text to columns - now paste does same

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.

John Keith wrote:

On Wed, 12 Sep 2007 08:39:27 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Start the "Data/ Text to columns" dialogue again. Deselect the comma
delimiter. At this stage you can cancel, and hopefully the paste will then
be OK.


That sounded like a plausible solution, however my testing tonight did
not support this suggestion.

But thank you for looking.

John Keith


--

Dave Peterson