[mso] Re: C & P'ing names and address into Excel from websites-

Robert.
If you don't get an answer from the list you might try copy and paste into
Word Pad - then copy and paste into Excel,
Been told Word Pad takes all the baggage out..

Another thing you might try if you have NS Works - copy and paste into that
and from there into Excel.

I have copied from the web lots of times (genealogy material) into Excel but
have found that sometimes I have to spread the columns before I can get into
Excel.

Luck
Alice
----- Original Message -----
From: "Robert Carneal" <carnealre@xxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, May 26, 2006 3:18 PM
Subject: [mso] C & P'ing names and address into Excel from websites-


> Hello everyone. I am hoping someone can offer some advice.
>
> I am trying to locate address of descendent of my ancestors. That is,
people
> like my gggg-grandfather's children, their children, and the children's
> children and so on.
>
> There are sites that will have names and addresses, but often are chock
full
> of other stuff such as buttons.
>
> Suppose a find a list of names that I believe I might have some luck with
by
> snail writing to them. I would like to capture / copy the name, address,
and
> phone number, and paste it in Excel, and build a list of people with a
high
> probability of being related to me.
>
> A list such as:
>
> John Doe Mark Smith Jane Brown
> 123 Walnut 1234 Apricot Way 65 Maple Avenue
> Indianapolis, IN 12345 New York, NY 22222 Miami, FL 57483
> 123-456-7890 333-444-5555 666-666-6666
>
> Kathy Bowman James Brown William Brown
> 333 Apple Way 444 Banana Ave 55 Coconut Drive
> St. Minrad, IN 33333 St Jose, TX 77222 Oklahoma Cty, OK 44444
> 343-434-3434 222-222-2222 999-999-9999
>
>
> Ok, my thinking was if it is already in a table of some kind, it would
copy
> and paste into Excel fairly well. It often does not. "65 Maple Avenue"
(Jane
> Brown's address in the right hand column) might paste into column CR (yes,
> *70* columns away from the left instead of just the third column!),
whereas
> Kathy Bowman's phone number might get pasted in Row 358.   In short, it is
> being pasted ostensibly at random cells instead of some kind of order.
And,
> if a person's phone number is not listed, then the next person's name is
put
> in the wrong cell, making the name and address off. If it would paste into
> Excel in some kind of reliable order, I can work with it.
>
> However, when I paste the above into a table is frequently disorganized.
It
> might look like this (Exaggeration):
> John Doe Mark Smith Jane Brown
> 123 Walnut 1234 Apricot Way 65 Maple Avenue
> Indianapolis, IN 12345 New York, NY 22222 Miami, FL 57483
> 123-456-7890 333-444-5555 666-666-6666
> Brown
> Kathy Bowman James William Brown
> 333 Apple Way 444 Banana Ave 55 Coconut Drive
> St. Minrad, IN 33333 St Jose, TX 77222 Oklahoma Cty, OK 44444
> 343-434-3434 222-222-2222 999-999-9999
>
> That is not of much use to me. <g>
>
> My question: Does anyone know how to capture names and address on a
website
> and paste it into Excel? This is not for a mass mailing list, I will
contact
> them one at a time, person to person via snail mail. Any ideas?
Suggestions?
> I tried SnagIt, which was advertised to capture text and save as text in
CVS
> format, but the trial version didn't do that. I tried something called
> "SelectiveCapture" (which is supposed to let you define what you want from
a
> web page, and I said name, address, town, state, zip, phone), but what it
> did was do that, and go on to get information from web sites I do not want
> information from. (too much information, in other words. Billy Joe-Bob
> MacKenzie might be a business partner of my ancestor, but I am not looking
> for him simply because my ancestor's name was hyper linked to Billy
Joe-Bob,
> just the information on the web page I see. I hope I am making sense. If I
> am not making sense- write me and I will give some more examples.
>
> If someone suggests a product to try, I will happily try it. I have a lot
of
> names I want to capture.
>
> Thank you.
>
> Robert
>
> *************************************************************
> 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, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
> http://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
>
> If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************

*************************************************************
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, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://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

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: