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