How do I get rid of new lines?
 

I have an excel spreadsheet that has a column where the text has been entered
in multiple lines. I need to convert this spreadsheet to a .dbf or an excel
document. Whenever I try, I lose the data after the first line. Any ideas on
how to keep all of the multi-line data? Thanks.

Melanie

How do I get rid of new lines?
 

To clarify, your excel document has "carriage returns" (multiple lines of
data) within a single excel cell?
Excel's CLEAN function should strip out the carriage returns and leave you
with a single, long line of text. Syntax is simple =CLEAN(A1) takes out the
carriage returns in cell A1, along with any other non-printable characters.

"lvbball23" wrote:

I have an excel spreadsheet that has a column where the text has been entered
in multiple lines. I need to convert this spreadsheet to a .dbf or an excel
document. Whenever I try, I lose the data after the first line. Any ideas on
how to keep all of the multi-line data? Thanks.

Melanie