Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
Lines separating rows and columns won't unhide | Excel Discussion (Misc queries) | |||
Partial Grid Lines | Excel Discussion (Misc queries) | |||
Add more lines and more columns in Excel | Excel Worksheet Functions |