My first post on Dr Excel !

I have a basic spreadsheet, and need to save as a CSV. There is a requirement to import a text file into an ERP system table.

After one of the column, I need to force a new line.

Example:

000040308|{\{txta 2| "Vessel is under maint. contract no.: 15444 for NAVIGATION EQUIPMENT, ONLY as follows:

EQUIPMENT COVERED:
- Gyro Compass Navigat X or Navigat X MK1 and Repeaters
- Speed Log Naviknot III FNF
- Auto Pilot Navipilot AD II
- Magnetic Compass Navipol 1
- Tiller Steering Naviguide NN



After the red "2|", I need the "Vessel is under......" to commence from a new line

Untitled.jpg is a snapshot of the excel sheet


Thank you all in advance