Hello, I wanted to reach out to see if it was possible to write a formula/function in VB to read and change the entire contents of a cell from Text to HTML format. Reason I asked is because I need to data load about 96,000 records in a CSV file, but in order to keep the format integrity/spacing/bullets etc. I have to convert it to HTML and then perform the data load. Below is an example. Any suggestions is greatly appreciated. ID for the Data LoadAnalysis (TEXT)What I need it to convert toa3334000000OIUH7.2.6 XM-customer reports that certain events are not appearing in Web Console dashboards-target logs not present in PM investigation-explained in depth the difference between logs and events, how GLPRs work, and the difference between ARM and AIE alarming criteria-customer's RBP threshold is 5 (set by Optiv). I recommended raising this to 20.-assisted customer with creation of 2 GLPRs. We did one using the GLPR wizard and another using the 'Create GLPR' button in Log Viewer-the customer had numerous questions along the way. We discussed how to check on the contents of a list, how lists get updated, and what the Threat Intelligence Service is-ultimately, the system was working as designed but the customer really needed training7.2.6 XM-customer reports that certain events are not appearing in Web Console dashboards-target logs not present in PM investigation-explained in depth the difference between logs and events, how GLPRs work, and the difference between ARM and AIE alarming criteria-customer's RBP threshold is 5 (set by Optiv). I recommended raising this to 20.-assisted customer with creation of 2 GLPRs. We did one using the GLPR wizard and another using the 'Create GLPR' button in Log Viewer- the customer had numerous questions along the way. We discussed how to check on the contents of a list, how lists get updated, and what the Threat Intelligence Service is-ultimately, the system was working as designed but the customer really needed training

Jlr18 Perhaps some approximation will be =""&SUBSTITUTE(A1,CHAR(10),"")

Copper Contributor

Nov 07, 2019

Solved

Is it possible to write a formula in Excel to convert a Column (Text) to HTML format?

Hello,

I wanted to reach out to see if it was possible to write a formula/function in VB to read and change the entire contents of a cell from Text to HTML format. Reason I asked is because I need to data load about 96,000 records in a CSV file, but in order to keep the format integrity/spacing/bullets etc. I have to convert it to HTML and then perform the data load.

Below is an example.

Any suggestions is greatly appreciated.

ID for the Data Load	Analysis (TEXT)	What I need it to convert to
a3334000000OIUH	7.2.6 XM -customer reports that certain events are not appearing in Web Console dashboards -target logs not present in PM investigation -explained in depth the difference between logs and events, how GLPRs work, and the difference between ARM and AIE alarming criteria -customer's RBP threshold is 5 (set by Optiv). I recommended raising this to 20. -assisted customer with creation of 2 GLPRs. We did one using the GLPR wizard and another using the 'Create GLPR' button in Log Viewer -the customer had numerous questions along the way. We discussed how to check on the contents of a list, how lists get updated, and what the Threat Intelligence Service is -ultimately, the system was working as designed but the customer really needed training	<p>7.2.6 XM</p> <p>-customer reports that certain events are not appearing in Web Console dashboards</p> <p>-target logs not present in PM investigation</p> <p>-explained in depth the difference between logs and events, how GLPRs work, and the difference between ARM and AIE alarming criteria</p> <p>-customer's RBP threshold is 5 (set by Optiv). I recommended raising this to 20.</p> <p>-assisted customer with creation of 2 GLPRs. We did one using the GLPR wizard and another using the 'Create GLPR' button in Log Viewer</p> <p>- the customer had numerous questions along the way. We discussed how to check on the contents of a list, how lists get updated, and what the Threat Intelligence Service is</p> <p>-ultimately, the system was working as designed but the customer really needed training</p>