Copying text into Excel

  • Thread starter Thread starter Malisa
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use Windows command within Excel macros 2
Copy/Past from Word-spreadsheet format alignment disregarded 3
Excel 2000 3
Text to Columns 1
Pasting from Word to Excel - Urgent 2
Pasting excel into word 1
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Text to Rows? 3

Back
Top