View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default 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