• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Input


New Member
Hi ya'all. I want to copy an unstructured piece of work from a website to my excel sheet. To be specific i'm inputting Infectious diseases and there symptoms and diagnosis. There's a database with all that but you have to check the symptoms per disease. I, however want to paste all the symptoms and diseases at a go. Is there a way to do this?
This is the file.



Excel Ninja
Please be more detailed in your requirement. Looking at your file. I have no idea what you are trying to do here.

Marc L

Excel Ninja
Hi !​
Is there a way to do this?
Maybe yes, maybe no, who knows ?! As you can start with an easy copy / paste operation …​
As here is the Excel formula forum so if you have an enough recent Excel version​
see the Excel help of the WEBSERVICE & FILTERXML worksheet functions …​