Move plain text metafield with some tags to html body

[Renars]

Hi @LottieKing

Renars here from Matrixify app. Thank you for using our app for this task and mentioning it here.

Found one solution which would be to use the Excel SUBSTITUTE formula to bulk replace the line breaks in the text with HTML <br> tags.

An example of the process could look like this:

1. You have a file with this Metafield where you have new line rows in the Metafields value. In the column next to the Metafield (add new one if there is already data in there), in row 2 add formula =SUBSTITUTE(F2,CHAR(10),"<br>"). This formula will change any occurrence of a specific text within cells value with another text.
   There are 3 parts of this formula (see also my example screenshot below):
   • F2 - is the column and row of the metafields text (you would need to change the F to your Metafield columns letter/s).
   • CHAR(10) - is the formula for a new line character.
   • 
     - Replace with
     for HTML line break.
2. Fill that formula till the end of the file’s data and you have generated the same metafield values but only with
   tags where there was a line break in the text.

Then you can use this within the Body HTML column to add the value to the description but without line breaks.

Hope this helps!