Remove HTML Upon Export to Excel?

mbelmont

Is there any way to get the returned value of HTML code to export to Excel instead of the code string itself?

 

For instance I have some codes that look like this:

 

CASE

WHEN IFNULL(`CX.TRACK.01`,'1/1/2099') = '1/1/2099'

THEN CONCAT('<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', 'Initial Review Needed!', '</a></div>')

END

 

Upon export the entire HTML string comes along.  Any thoughts?

kshah008

Hi all,

Can anybody help @mbelmont out?

Thanks!

Hua

I would like to know if there is any solution to this too.

user08419

I would love to know if there is a solution for this