Excel 2002 cannot copy data from website to excel

G

Guest

I have data in a website that looks like the following

US 04872 - CASS CITY CASMI CTR 2
US 04881 - FLINT-SOUTH 4881 CTR 2
US 04885 - MOUNT PLEASANT MTPMI CTR 2

In previous versions of excel, when I copy this data it would put
US in column
04872 in column
- in column
CASS CITY in column 4 and so on

The problem is now when I copy this data and try to paste it into Excel 2002 I receive the following error "Microsoft Excel cannot paste data"

What should I do? - Paste Special as text is not a good option cause it doesn't retain my cells. HELP
 
J

Jim Rech

I don't know why you're getting this error but you might try pasting as text
and then use Data, Text to Columns to parse it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel 2007 I cannot Paste anymore? 2
Cannot copy worksheet to another file 2
copy outlined data in excel 1
Excel Spreadsheet combining data from 3 columns to 1 column 3
COPY EXCEL 2007 9
Sudden Change in Copy & Paste Format 2
Copy-Paste Chart into Word from Excel 2007 3
Printing from website to Excel 3

Top