Data being delimited when pasting

[sgs521]

Hello,
I have a user who is running into a problem when pasting copied
selections from web pages.
The information is displayed on the web page in multiple columns
(actually formatted into tables with multiple rows and colums, not
just text formatting), when it is copied and pasted into a worksheet
in excel, the formatting breaks and anything with a space or comma
appears to separate the information into their own columns, so instead
of having three or four columns as the original source did, it may
span across 7 or 8 columns..
I cannot seem to reproduce the error on my own machine, pasting the
same data into a worksheet formats perfectly for me. I am relatively
new to mac's and this version of office, so I am at a loss. Anyone
have any info on the possible causes of the problem?

Thanks!

 

[jpdphd]

Hello,
I have a user who is running into a problem when pasting copied
selections from web pages.
The information is displayed on the web page in multiple columns
(actually formatted into tables with multiple rows and colums, not
just text formatting), when it is copied and pasted into a worksheet
in excel, the formatting breaks and anything with a space or comma
appears to separate the information into their own columns, so instead
of having three or four columns as the original source did, it may
span across 7 or 8 columns..
I cannot seem to reproduce the error on my own machine, pasting the
same data into a worksheet formats perfectly for me. I am relatively
new to mac's and this version of office, so I am at a loss. Anyone
have any info on the possible causes of the problem?

Thanks!

I think that if you have used the Data > Text to Columns... command
during an Excel session, Excel 'learns' the pattern you established
and will re-use it when you paste something that 'looks' similar.
(Excel appears to anticipate your next move - very sneaky). I have
seen this. The cure I found was to save the worksheet to the condition
before the screwy paste (undo the paste), quit excel and open the file
anew. This seems to be what it takes for Excel to forget.

jpdphd