[pcductape] Re: Fw: [PC-Ductape] Spreadsheet question

  • From: "Lori Gebhart" <ggebhart@xxxxxxxxxx>
  • To: <pcductape@xxxxxxxxxxxxx>
  • Date: Wed, 24 Dec 2003 09:22:19 -0500

Hi Carl,

You are quite welcomed.  Glad I could help. :)

Lori

-----Original Message-----
From: pcductape-bounce@xxxxxxxxxxxxx
[mailto:pcductape-bounce@xxxxxxxxxxxxx] On Behalf Of Carl
Sent: Wednesday, December 24, 2003 7:18 AM
To: pcductape@xxxxxxxxxxxxx
Subject: [pcductape] Re: Fw: [PC-Ductape] Spreadsheet question


Hi Lori,

Thank you, Thank you, Thank you.
Be Blessed.   I used Excel 2002 and yes, it works.   Wow!
My earlier messages were based on MsWorks spreadsheet which is fast and
easy but not for websites.  Incidentally when I did do the copy from the
website and the paste I shut down the website, then my firewall asked if
I wanted to allow Excel Internet Access and then Excel opened the
website as it pasted
the info to an Excel spreadsheet .   I can even delete the account
number
column that I don't need.

Thanks again.

When I looked at the "source" of that website at http://www.hcad.org I
noticed that the author created the page on 3-30-2001 (before Excel
2002)
and he used JavaScript.   It looks like he use ";" to separate the
columns.
When I looked at the properties of that page I see that it is in
HyperText Transfer Protocol and is not protected, which tells me the
owner of the
website want people to copy & paste.   :-)

Carl



----- Original Message ----- 
From: "Lori Gebhart" <ggebhart@xxxxxxxxxx>
To: <pcductape@xxxxxxxxxxxxx>
Sent: Tuesday, December 23, 2003 8:25 PM
Subject: [pcductape] Re: Fw: [PC-Ductape] Spreadsheet question


> Carl,
>
> I highlighted the whole table on the web page, control C to copy, went

> to the spreadsheet, clicked on A1 and control V to paste.
>
> Everything (All rows and columns) seperated just the way its supposed 
> to.
>
> I have Office 2000 and used Excel to do this.
>
> Hopefully it works for you the same way if you have the same version 
> of Office.
>
> Lori
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: pcductape-bounce@xxxxxxxxxxxxx 
> [mailto:pcductape-bounce@xxxxxxxxxxxxx] On Behalf Of Carl
> Sent: Tuesday, December 23, 2003 9:36 AM
> To: pcductape@xxxxxxxxxxxxx
> Subject: [pcductape] Re: Fw: [PC-Ductape] Spreadsheet question
>
>
> Hi Scott,
>
> Thanks for your reply.  I have tried many ways to get a good mailing 
> list
> using a spreadsheet to sort but cannot.   Let me be truthful;   I am
> trying
> to developed or capture a mailing list off the public records 
> databases of
> the Internet.   I am interested only in zipcode 77346 which has
> approximately 12,000 postal addresses and I can buy the mailing list. 
> But,
> I am cheap.   I know that the state of Texas collects property and
> school
> taxes based on records kept by "Tax Appraisal Districts", which are 
> the government agencies  that determine how much we pay in property &
school
> taxes.   Texas has an "open records" law that require public data to
be
> disclosed when needed.   For some reason I don't understand, the tax
> appraisal districts have all their databases on the Internet 
> accessible to
> anyone with the desire to go get them.    At http://www.hcad.org/, one
> can
> "walk" down the block of any street and capture the names and 
> addresses and
> zipcodes of all who live on that block.   That is what I am trying to
do
> but
> when I copy from the website to my spreadsheet, the results are that
the
> name and address and zipcode are all in the same column.   Darn.   I
> know
> there has to be a way to move the address to column B.   No need to
move
> the
> zipcode because they are all the same.
>
> I will work some more tonight on your suggestions.
> Btw, my street is Hickory Wind Drive, 77346 and to walk down the block

> one needs to enter beg:18000 and end:29999 and it will pop up about 40

> names and addresses.
>
> Thanks,
> Carl
>
>
>
> ----- Original Message -----
> From: "Scott McNay" <Wizard@xxxxxxxx>
> To: "Carl" <pcductape@xxxxxxxxxxxxx>
> Sent: Tuesday, December 23, 2003 7:44 AM
> Subject: [pcductape] Re: Fw: [PC-Ductape] Spreadsheet question
>
>
> >
> > Hi Carl,
> >
> > Oops, I meant to say...
> >
> >    Mark cells B1 through C3, and copy. Then, mark cells B4 through
> >    the last row of C, then paste.
> >
> > Doing it the way that I said originally will keep the sort from 
> > doing anything useful.
> >
> > --Scott.
> >
> >
> > Tuesday, December 23, 2003, 4:50:03 AM, you wrote:
> >
> > C> Thanks Scott.
> > C> Carl
> >
> > C> ----- Original Message -----
> > C> From: "Scott McNay" <Wizard@xxxxxxxx>
> > C> To: "Carl" <pcductape@xxxxxxxxxxxxx>
> > C> Sent: Monday, December 22, 2003 10:59 PM
> > C> Subject: [pcductape] Re: Fw: [PC-Ductape] Spreadsheet question
> >
> >
> > >>
> > >> Hi Carl,
> > >>
> > >> Monday, December 22, 2003, 10:55:33 AM, you wrote:
> > >>
> > >> C> I was in too big a hurry and failed to explain my problem 
> > >> C> properly. Somehow my spreadsheet of names and addresses became

> > >> C> corrupt and I
> have
> > C> one
> > >> C> person's name on line 1a and his address on line/row 2a and 
> > >> C> his
> zipcode
> > C> on
> > >> C> line/row 3a. I am trying to convert "row 2a" into column 1b 
> > >> C> and "row 3a" into column 1c.
> > >>
> > >> If this is a one-shot thing, here's what you can do:
> > >>
> > >> In cell B1, type the formula
> > >>
> > >>    =A2
> > >>
> > >> In cell C1, type the formula
> > >>
> > >>    =A3
> > >>
> > >> Mark cells B1 and C1, and copy.  Then, mark cells B2 through the 
> > >> last row of C, then paste.
> > >>
> > >> Then, mark cells A1 through the last cell of C, copy, then 
> > >> right-click on the marked area and select Paste Special.  When 
> > >> prompted, pick "Values", hen click Ok.  This replaces the 
> > >> formulas with the actual text.
> > >>
> > >> Then, you can go through and sort the list by column B, then you 
> > >> can mark the 200 short lines and then delete them.
> > >>
> > >>
> > >> --Scott.
> > >>
> > >>
> > >> To unsubscribe from this list send an email to 
> > >> pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject

> > >> field OR by logging into the Web interface.
> >
> > C> To unsubscribe from this list send an email to 
> > C> pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject

> > C> field OR by logging into the Web interface.
> >
> >
> > --Scott.
> >
> >
> > To unsubscribe from this list send an email to 
> > pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject 
> > field OR by logging into the Web interface.
>
> To unsubscribe from this list send an email to 
> pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject 
> field OR by logging into the Web interface.
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003
>
>
> To unsubscribe from this list send an email to 
> pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject 
> field OR by logging into the Web interface.

To unsubscribe from this list send an email to
pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject field
OR by logging into the Web interface. 

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003
 

To unsubscribe from this list send an email to
pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject field
OR by logging into the Web interface. 

Other related posts: