[mso] Re: Send the url please : Pasting data into excel, prob lem
- From: David Good - ANSYS Europe <david.good@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Fri, 17 Jan 2003 13:07:40 -0500
Maybe it's a version thang! I'm using XP versions of Excel in Word. Did you
paste the table into Word first?
I got it all into Excel using this method, I then got rid of the extra
returns between the names by doing some sort trickery. I could send you the
sheet, but I guess that defeats the object :D let me know ASAP if you want
me to send it! I'm just about to leave the office for the weekend.
Dave.
-----Original Message-----
From: Hough, John [mailto:jhough@xxxxxxxxx]
Sent: 17 January 2003 18:01
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Send the url please : Pasting data into excel, prob lem
david,
Not treading at all, anyone that can help is appreciated. ok, I formatted
the column that the H/AB goes in to Text before pasting and no luck, I even
formatted the whole sheet to text cells before pasting and no luck. Did it
work for you? Still doesn't work for me.
-----Original Message-----
From: David Good - ANSYS Europe [mailto:david.good@xxxxxxxxx]
Sent: Friday, January 17, 2003 9:40 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Send the url please : Pasting data into excel, prob lem
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
*************************************************************
*************************************************************
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
*************************************************************
*************************************************************
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
*************************************************************
Other related posts:
