Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / October 2007



Tip: Looking for answers? Try searching our database.

Data being delimited when pasting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sgs521@gmail.com - 01 Oct 2007 22:44 GMT
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 - 03 Oct 2007 03:37 GMT
On Oct 1, 5:44 pm, sgs...@gmail.com wrote:
> Hello,
> I have a user who is running into a problem when pasting copied
[quoted text clipped - 12 lines]
>
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.