I have a spreadsheet that has a couple of columns with formatted text - mainly bolds and italics.
I'd like to be able to create another column that converts that to html so it can be extracted and displayed via a html viewer.
So if the existing data says:
Keyword: Do something quickly
I'd like the new cell to say
<b>Keyword:</b> Do <i>something</i> quickly
Is this possible ? I've done some google searching and found examples where some clever VBA turns the entire spreadsheet / worksheet into an html document but I just want to be able to add a new column and then replicate all the contents of formatted column into the new column, converting the formatting to HTML.
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…