Problem pasting data to Excel

S

shawshank

I need to paste some data from an Oracle application to Excel (data being
pasted is basically a Tab delimited text stream) and having following
problem: Excel separates the spaces in data fields and put them in different
cells. To get around the problem, I have to first paste data to a text
editor, e.g. Notebook, then open the file in excel, then choose "delimited",
then make sure only "Tab" is selected.
I also found the problem only happens on my computer and I am sure it must
be a setting somewhere in Excel that has caused this.

Can someone help here?

Thanks,
 
C

CLR

I have had similar experiences, not from Oracle but on other text files
whereas the same automatic separation of values into columns occurs. But it
seems in my situation it's only after once having used the Data >
TextToColumns feature in "that" session of Excel. Your case may be similar
and may go away if you do your importing on a "fresh" session of Excel.

hth
Vaya con Dios,
Chuck, CABGx3
 

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

Top