Excel and tab delimited files, using Carriage return and Line Field

Question

How do you introduce a CR and LF into a cell so when it is saved as a Tab delimited text file, the importing program will recognize the CR and LF?

Answer 1

You can use the ASCII character codes in the cell:

Line Feed =CHAR(10)

Carriage Return =CHAR(13)

If need be, copy and paste values to get rid of the formula.

Answer 2

You must use CRLF at the end of every row, and LF for carriage return inside a cell

In this way a spreadsheet will read properly the input