Free form Text to Rich Text ADD HTML

Normal Text to Rich Text

If you have MS Excel, you can use the Replace (Ctrl + H) functionality.

Steps:

1. Open your Excel file
2. Press Ctrl + H on your keyboard
3. Click the “Find what:” box, then press Ctrl + J on your keyboard
4. Click the “Replace with:” box then put in <br>
5. Click Replace All
6. Save the file as a CSV

It is important that your initial file should be an Excel file, and not a CSV, since only Excel files retain the line break (Ctrl + J) from the system.

So, assuming that you ran a Saved Search to get the value of the “Message” field, then you need to save it as an Excel file first.

If you save it as a CSV coming straight from the Saved Search, the line breaks are just treated as regular white spaces and you can’t really do the Ctrl + J trick.

other Ref

ctrl h, ctrl j, <BR>

=TRIM(D2)

=IF(LEFT(E11,4)=”<br>”,MID(E11,5,LEN(E11)-4),E11),

 

 

=SUBSTITUTE(IF(LEFT(A1,4)=”<br>”, MID(A1,5,LEN(A1)-4), A1), “<br><br>”, “<br>”)