I am trying to find a way to properly import a text file into excel that contains a carriage return using the Get External Data option.
The file has a text qualifier and is pipe delimited. Here is some example data.
"1"|"test data" "2"|"test data with a line break"
It should import 2 rows with a line break in row 2 column 2. However, it ends importing it as 3 rows.
I tried playing with the File origin settings to see if the different encodings made a difference but they do not.