Not meaning to tread on any answers but in case this helps a little... Taking it via Word helps some in cases like this; you can then get copying a column at a time using paste special. The one problem I have here is that the name column has an extra return, so you get an extra blank line between items. The H/AB column pastes fine as long as you set the cell format to TEXT *before* you paste the data. HTH, otherwise I'm sure Jacques will fid you a good solution. Dave. -----Original Message----- From: Hough, John [mailto:jhough@xxxxxxxxx] Sent: 17 January 2003 17:13 To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Send the url please : Pasting data into excel, problem Thanks Jacques. Here's the URL. I'm trying to copy/paste the entire table on this page, the column that has the problem is the H/AB column. Thanks. http://games.espn.go.com/diamond/pickarchive?entryID=22525 -----Original Message----- From: Jacques De Schryver [mailto:jds@xxxxxxx] Sent: Thursday, January 16, 2003 10:13 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Send the url please : Pasting data into excel, problem If you want I tinker the problem, please send the url, unless it is very confidential. Jacques -- Jacques De Schryver http://jdsetls.virtualave.net/ Last photo : http://shuttercity.com/ShowPhoto.cfm?PhotoID=51638 http://membres.lycos.fr/lsteven/ ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************