Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to take a list of names & addresses from web site into Excel
I am on a website that has a large list that I would like to copy into Excel.
It does not open into a new window. It's just there on the page and are grouped by individual business like this: Name Address City, St Zip Phone Name Address City, St Zip etc... I would like to put it into Excel with headings across of Name, Address, etc. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to take a list of names & addresses from web site into Excel
One way you can do this is as follows
1. Copy all the addresses and paste them into Excel This will get you address1 in A1-A4, address2 in A6-A9 and so on Now paste this formula in B1 =INDIRECT("R"& (ROW()-1)*5+(COLUMN()-1) &"C1",FALSE) and copy across to B5 then down till the row no. equal to the no of addresses you have. Once you get it right then you can copy and Past Special|Values to remove formulas... If you want to separate City, St Zip then you can choose that column and do Data|Text to Columns... "vtrud" wrote: I am on a website that has a large list that I would like to copy into Excel. It does not open into a new window. It's just there on the page and are grouped by individual business like this: Name Address City, St Zip Phone Name Address City, St Zip etc... I would like to put it into Excel with headings across of Name, Address, etc. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to take a list of names & addresses from web site into Exc
Sorry I meant copy across to E1
(instead of copy across to B5 ) "Sheeloo" wrote: One way you can do this is as follows 1. Copy all the addresses and paste them into Excel This will get you address1 in A1-A4, address2 in A6-A9 and so on Now paste this formula in B1 =INDIRECT("R"& (ROW()-1)*5+(COLUMN()-1) &"C1",FALSE) and copy across to B5 then down till the row no. equal to the no of addresses you have. Once you get it right then you can copy and Past Special|Values to remove formulas... If you want to separate City, St Zip then you can choose that column and do Data|Text to Columns... "vtrud" wrote: I am on a website that has a large list that I would like to copy into Excel. It does not open into a new window. It's just there on the page and are grouped by individual business like this: Name Address City, St Zip Phone Name Address City, St Zip etc... I would like to put it into Excel with headings across of Name, Address, etc. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to take a list of names & addresses from web site into Exc
Okay, sorry to sound ignorant but what am I missing. I have done as directed
below but how do I get the data to fill? Is there a step missing? "Sheeloo" wrote: Sorry I meant copy across to E1 (instead of copy across to B5 ) "Sheeloo" wrote: One way you can do this is as follows 1. Copy all the addresses and paste them into Excel This will get you address1 in A1-A4, address2 in A6-A9 and so on Now paste this formula in B1 =INDIRECT("R"& (ROW()-1)*5+(COLUMN()-1) &"C1",FALSE) and copy across to B5 then down till the row no. equal to the no of addresses you have. Once you get it right then you can copy and Past Special|Values to remove formulas... If you want to separate City, St Zip then you can choose that column and do Data|Text to Columns... "vtrud" wrote: I am on a website that has a large list that I would like to copy into Excel. It does not open into a new window. It's just there on the page and are grouped by individual business like this: Name Address City, St Zip Phone Name Address City, St Zip etc... I would like to put it into Excel with headings across of Name, Address, etc. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to take a list of names & addresses from web site into Exc
After typing or pasting the formula in B1...
Copy B1 Select the range B1:E100 and press CTRL-V to paste the formula... If this does not work then pl. list the steps you are performing so that I can try and help you. "vtrud" wrote: Okay, sorry to sound ignorant but what am I missing. I have done as directed below but how do I get the data to fill? Is there a step missing? "Sheeloo" wrote: Sorry I meant copy across to E1 (instead of copy across to B5 ) "Sheeloo" wrote: One way you can do this is as follows 1. Copy all the addresses and paste them into Excel This will get you address1 in A1-A4, address2 in A6-A9 and so on Now paste this formula in B1 =INDIRECT("R"& (ROW()-1)*5+(COLUMN()-1) &"C1",FALSE) and copy across to B5 then down till the row no. equal to the no of addresses you have. Once you get it right then you can copy and Past Special|Values to remove formulas... If you want to separate City, St Zip then you can choose that column and do Data|Text to Columns... "vtrud" wrote: I am on a website that has a large list that I would like to copy into Excel. It does not open into a new window. It's just there on the page and are grouped by individual business like this: Name Address City, St Zip Phone Name Address City, St Zip etc... I would like to put it into Excel with headings across of Name, Address, etc. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
How do I easily divide an excel list of names/addresses among 6 pe | New Users to Excel | |||
Look up Webpage addresses from a List of company names in Excell? | Excel Worksheet Functions | |||
How do I create a list of names and addresses? | Excel Discussion (Misc queries) | |||
How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) |