Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
When I copy and paste to a workbook the USA TODAY NFL spreads, I lose every
other row such as follows: A B C D 1 BUFFALO 5½ N.Y. Jets 34½ 3 PITTSBURGH 2 Cincinnati 41½ 5 INDIANAPOLIS 7 Jacksonville 44½ 7 MIAMI 11 Tennessee 36 THERE IS AN A2 CELL BUT NO B2, C2, OR D2 CELL...THE A2 CELL STRETCHES AS FAR AS D2...LIKEWISE FOR CELLS A4, A6, A8, ...,ETC. hOW CAN I FIX THIS SO THAT MY COPY AND PASTE COVERS all CELLS (SO i CAN APPLY FORMULAS, ETC.)????? PLEASE ADVISE. Thank you, FLKulchar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
Have you tried DATA/IMPORT EXTERNAL DATA/NEW WEB QUERY?
This lets you pick and choose the tables on the website of your choice. -- Kevin Backmann "F. Lawrence Kulchar" wrote: When I copy and paste to a workbook the USA TODAY NFL spreads, I lose every other row such as follows: A B C D 1 BUFFALO 5½ N.Y. Jets 34½ 3 PITTSBURGH 2 Cincinnati 41½ 5 INDIANAPOLIS 7 Jacksonville 44½ 7 MIAMI 11 Tennessee 36 THERE IS AN A2 CELL BUT NO B2, C2, OR D2 CELL...THE A2 CELL STRETCHES AS FAR AS D2...LIKEWISE FOR CELLS A4, A6, A8, ...,ETC. hOW CAN I FIX THIS SO THAT MY COPY AND PASTE COVERS all CELLS (SO i CAN APPLY FORMULAS, ETC.)????? PLEASE ADVISE. Thank you, FLKulchar |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
also, if you stick with pasting, after you have pasted, select column 1 and
do Data=Text to Columns, select delimited and then select space as delimiter on the next tab in the wizard. -- Regards, Tom Ogilvy "F. Lawrence Kulchar" wrote: When I copy and paste to a workbook the USA TODAY NFL spreads, I lose every other row such as follows: A B C D 1 BUFFALO 5½ N.Y. Jets 34½ 3 PITTSBURGH 2 Cincinnati 41½ 5 INDIANAPOLIS 7 Jacksonville 44½ 7 MIAMI 11 Tennessee 36 THERE IS AN A2 CELL BUT NO B2, C2, OR D2 CELL...THE A2 CELL STRETCHES AS FAR AS D2...LIKEWISE FOR CELLS A4, A6, A8, ...,ETC. hOW CAN I FIX THIS SO THAT MY COPY AND PASTE COVERS all CELLS (SO i CAN APPLY FORMULAS, ETC.)????? PLEASE ADVISE. Thank you, FLKulchar |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
I tried this...the problem is, when I pasted the image into my workbook, it
was dumped into 5 columns...NOT 1...therefore, "text to columns" did not work. pls. advise, flkulchar "Tom Ogilvy" wrote: also, if you stick with pasting, after you have pasted, select column 1 and do Data=Text to Columns, select delimited and then select space as delimiter on the next tab in the wizard. -- Regards, Tom Ogilvy "F. Lawrence Kulchar" wrote: When I copy and paste to a workbook the USA TODAY NFL spreads, I lose every other row such as follows: A B C D 1 BUFFALO 5½ N.Y. Jets 34½ 3 PITTSBURGH 2 Cincinnati 41½ 5 INDIANAPOLIS 7 Jacksonville 44½ 7 MIAMI 11 Tennessee 36 THERE IS AN A2 CELL BUT NO B2, C2, OR D2 CELL...THE A2 CELL STRETCHES AS FAR AS D2...LIKEWISE FOR CELLS A4, A6, A8, ...,ETC. hOW CAN I FIX THIS SO THAT MY COPY AND PASTE COVERS all CELLS (SO i CAN APPLY FORMULAS, ETC.)????? PLEASE ADVISE. Thank you, FLKulchar |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
A2 CELL STRETCHES AS FAR AS D2
was what I was going on, which, to me, said it was all in one column. As Don Said, post the URL so we can see if we can reproduce the problem and suggest a fix. -- Regards, Tom Ogilvy "F. Lawrence Kulchar" wrote in message ... I tried this...the problem is, when I pasted the image into my workbook, it was dumped into 5 columns...NOT 1...therefore, "text to columns" did not work. pls. advise, flkulchar "Tom Ogilvy" wrote: also, if you stick with pasting, after you have pasted, select column 1 and do Data=Text to Columns, select delimited and then select space as delimiter on the next tab in the wizard. -- Regards, Tom Ogilvy "F. Lawrence Kulchar" wrote: When I copy and paste to a workbook the USA TODAY NFL spreads, I lose every other row such as follows: A B C D 1 BUFFALO 5½ N.Y. Jets 34½ 3 PITTSBURGH 2 Cincinnati 41½ 5 INDIANAPOLIS 7 Jacksonville 44½ 7 MIAMI 11 Tennessee 36 THERE IS AN A2 CELL BUT NO B2, C2, OR D2 CELL...THE A2 CELL STRETCHES AS FAR AS D2...LIKEWISE FOR CELLS A4, A6, A8, ...,ETC. hOW CAN I FIX THIS SO THAT MY COPY AND PASTE COVERS all CELLS (SO i CAN APPLY FORMULAS, ETC.)????? PLEASE ADVISE. Thank you, FLKulchar |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from WEB SITE
http://www.usatoday.com/sports/gaming/sheridan.htm
is the WEB SITE.. I copy the NFL spreads only, and when I paste, it goes into 5 columns... please advise, flkulchar "Tom Ogilvy" wrote: A2 CELL STRETCHES AS FAR AS D2 was what I was going on, which, to me, said it was all in one column. As Don Said, post the URL so we can see if we can reproduce the problem and suggest a fix. -- Regards, Tom Ogilvy "F. Lawrence Kulchar" wrote in message ... I tried this...the problem is, when I pasted the image into my workbook, it was dumped into 5 columns...NOT 1...therefore, "text to columns" did not work. pls. advise, flkulchar "Tom Ogilvy" wrote: also, if you stick with pasting, after you have pasted, select column 1 and do Data=Text to Columns, select delimited and then select space as delimiter on the next tab in the wizard. -- Regards, Tom Ogilvy "F. Lawrence Kulchar" wrote: When I copy and paste to a workbook the USA TODAY NFL spreads, I lose every other row such as follows: A B C D 1 BUFFALO 5½ N.Y. Jets 34½ 3 PITTSBURGH 2 Cincinnati 41½ 5 INDIANAPOLIS 7 Jacksonville 44½ 7 MIAMI 11 Tennessee 36 THERE IS AN A2 CELL BUT NO B2, C2, OR D2 CELL...THE A2 CELL STRETCHES AS FAR AS D2...LIKEWISE FOR CELLS A4, A6, A8, ...,ETC. hOW CAN I FIX THIS SO THAT MY COPY AND PASTE COVERS all CELLS (SO i CAN APPLY FORMULAS, ETC.)????? PLEASE ADVISE. Thank you, FLKulchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with copy & paste from Visa web site | Excel Worksheet Functions | |||
Copy/Paste into a spreadsheet that is posted to a Sharepoint site | Excel Discussion (Misc queries) | |||
how to copy Excel file on to a web site? | New Users to Excel | |||
Copy table from web site | Excel Discussion (Misc queries) | |||
Copy and Paste from Web Site | Excel Discussion (Misc queries) |