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,
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,