How do I get rid of new lines?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Starting a new line 2
Adding a new line to an existing graph, using excel 2007 1
Windows 10 How to get rid of lines on documents 2
How do i return muliple lines of data. 3
How can i get rid of two red lines on my spreadsheet? 2
copy 1 document and when original updated copy is also 4
Line Breaks in cells - Mac OS X Leopard 1

Back
Top