The text file that i am trying to import looks like this:

Field 1 <tab> Field 2 <tab> Field 3.1(CR)Field 3.2(CR)Field 3.3<tab>Field 4

where <tab> is Tab, and (CR) is carriage return. When importing into Excel, i want all 3 lines in Field 3 (Field 3.1, Field 3.2 and Field 3.3) be in one cell, but multiline. So basically i want excel to ignore carriage return. How do i do that???
I have some control on which characters to use to delimit the text file (e.g. i can change <tab> and (CR) to whatever i want. here is what i have tried so far:

changed (CR) character to carriage return (Ascii 13)
changed (CR) character to Line Feed (Ascii 10)
changed (CR) character to carriage return + Line Feed (Ascii 13 + Ascii 10)
Tried enclosing Field 3.1(CR)Field 3.2(CR)Field 3.3 into single or double quotes.

none of these seem to work: I get this in output:
Field 1 Field 2 Field 3.1
Field 3.2
Field 3.3 Field 4

does anyone know of a solution. it would be greatly appreciated