AboutPricing

Get instant live expert help on I need help with html to excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    I have list of html files in a folder and I need to read the html from every html file and display in excel using vba
    Solved by X. J. in 23 mins
    Hi..i have saved my excel file as .html.. now i want to know how can i enter data in that .html file. suppose this scenario... 100 15% 115 now i want to enter 200 in that column so that i can get 15% of 200. How can i enter 200 in that html page..??
    Solved by D. D. in 30 mins
    I need to fetch the data from list of html files placed under one folder and display in excel
    Solved by C. S. in 19 mins
    i am trying to upload external web data onto my excel doc. However, i do not have a "from web" option, i just have "from HTML" option. When i click on the "from HTML" option, it just takes me to my finder, not the web browser? what do i do?
    Solved by C. C. in 28 mins
    I have a formula that was created by you guys =CONCATENATE("<html>", " ",MID(C1,SEARCH("<h5>Item Description</h5>",C1),SEARCH("<!-- LISTING TERMS TEXT GOES HERE -->",C1)-SEARCH("<h5>Item Description</h5>",C1))," ","</html>") Which takes out certain paragraphs, texts, sentences and preserves the paragraph I need. I need either a revision of the formula so i can apply it to future sheet and make it a universal formula. OR.. I need step by step on what to input to make this formula work. So the sample column I am showing is all html cells. And they are once cell from each different excel sheets to show that the formula needs to work for each cell while i input the right text in the formula). EXAMPLE OF FORMULA USED First cell (c1) shows the cell that needs to be modified and (d1) uses the formula and shows which text is preserved and others are omitted. =CONCATENATE("<html>", " ",MID(C1,SEARCH("<h5>Item Description</h5>",C1),SEARCH("<!-- LISTING TERMS TEXT GOES HERE -->",C1)-SEARCH("<h5>Item Description</h5>",C1))," ","</html>") I pasted formula again and the last session the expert told me the three search terms is where input some of the words to make the formula work. So hopefully you can help me with A3 to A14 on what to input for each individual cell. (as mentioned the each cell is representation of a sheet that has lot of data)
    Solved by T. L. in 19 mins