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.
Is this possible ?