Copying text into Excel

M

Malisa

When copying text into excel, 2002 is reading ", " (comma
space combo) as a comma delimited and splitting the text
into two separate cells. Is there any way to turn this
function off so I can just paste it as preformatted. This
data is coming from an Oracle application and paste
special is not available.
 
D

Dave Peterson

Excel likes to be helpful.

If you've run a Data|text to columns, then excel remembers those settings. And
I bet you used a comma as a delimiter.

You can either close and reopen excel to reset this (yechhhh!).

Or do a dummy Data|text to columns.
put some junk in an unused cell
select that cell
data|text to columns
delimited
but uncheck all the delimiters
finish up and clean up that dummy data.

Now try pasting your other data once more.
 
Top