Using Excel, I past from a table brom a web site and excel puts everything in one cell

5 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
Using Excel 2003, I paste from a table on a web site and excel puts everything in one cell. I have had no problem until today. It seems excel is not recognizing the seporators as it did before. I am using CTR-C and CTR-V to bring the data into my spreadsheet.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Is it happening with all tables that you are trying copying or has happened with one table that you copied from a web page? I think the table on that web page was not properly formatted and thus this happened. Usually a table copied form word or a web page is properly pasted on an excel sheet in a pre-formatted manner.

For this issue, otherwise you can use Data Text to Columns option to convert a non formatted table to a formatted table.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Technochic
    It could be the site. Is this one you have done this successfully from before? Have you tried it from any other site?
    57,010 pointsBadges:
    report
  • Findsarfaraz
    Import from website is a goog website to resolve your issue
    1,395 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following