I have a spreadsheet that is the result of an export from another system. All of the cells export cleanly except for the description field, which exports as HTML code within the cell value. Within this HTML code is the actual text that should be the final value of the field, but I am unsure if there is a quick and easy way to clean up the cell value to be just the text. Here is a sample of one of the cell values:
"<HTML><HEAD><TITLE>HtmlEditor</TITLE>
<STYLE type=text/css>BODY {
PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: 400; FONT-SIZE: 10pt; PADDING-BOTTOM: 0px; MARGIN: 0px; COLOR: #000000; PADDING-TOP: 0px; FONT-FAMILY: Microsoft Sans Serif
}
</STYLE>
</HEAD>
<BODY><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Review
over states that have enforced Rule 14 to ensure that anyone who works in the
state and makes over a specified amount of money during their stay must file a
state tax return.</SPAN></BODY></HTML>"
The text that is needed is the part at the end that says "Review over states..." Does anyone know an easy way to extract this information from each of the cells, or will we just have to manually do so each time we run the report.
Let me know if you need further deatils.
Bookmarks