As users of Excel may know, only one hyperlink is allowed per cell. I'm trying to import HTML tables in which there are sometimes two hyperlinks per cell. The Excel importer does not seem to like this, so it gets rid of the link. Is there any way around this? [more inside]
Saving an Excel file with images as web page - why are thumbnails being created? [more inside]
How do I import tables from HTML into Excel when some cells have multiple lines? [more inside]
I would like to take the information from this Wikipedia page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
How can I force Excel 2007 to save as a single html file? [more inside]
How to extract data automatically from a group of HTML pages to an Excel file or to a database? [more inside]
I want to take an Excel spreadsheet and just make it a dynamically sortable table I can put in a webpage or blog. I want people to be able to click a column, and have the table be sorted by that column. Best solutions? Also, if the table included locations, is it possible to make them selectable, and have the selected locations display on Google maps? Thanks.
I have a large excel spreadsheet that contains various html tags, mainly bold and anchor tags (in upper case and lower case). How can i automagically remove them? [more inside]
Hi, hoping some MS Excel or HTML wizards can help me out with this. The goal is as follows; format a list of domain names so I can publish them on a webpage with hyperlinks to their individual addresses (currently they are all in Excel with each domain occupying a single cell in a single row; they are currently formatted like this: "domain.com"). There are just to many to go through and add this to each one. [more inside]
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
Excel's built-in conversion to HTML results in a monstrosity of a web page. Can anyone recommend the best "scrubber" or converter utility that does the best job (Windows or Mac)?