|
|
||||||
|
#1
11-02-04, 10:18 PM
|
|
|
|
|
I have a series of cells in Excel with line breaks embedded within them.
When I go to save the worksheet as a .txt file, this corrupts the data. Search and replace does not detect them. |
|
|
|
#2
11-03-04, 01:19 AM
|
|
|
|
|
If you used alt-enters, you should be able to use edit|replace to get rid of
them: Edit|replace what: alt-0010 (hit and hold the alt key and type 0010 on the numeric keypad) with: (spacebar) (or whatever you want) Replace all. It may not look like xl is putting anything in, but try it anyway. Holly wrote: [..] |
|
|
| Similar Threads | |
| how do I remove line breaks from several cells? I have imported labels (formatted as first/last name, address, city/state/zip with line breaks between in each cell) and need utilize the "text to colums" in order to mail... |
|
| Line breaks in my cells... Hello! I received an excel worksheet that contains "line break" characters in some of the cells and they cause me a lot of trouble. How do I eliminate them? I tried "Find... |
|
| remove manual line breaks at the end of each line of txt I'm importing text from PDF w/out having Acrobat. Word has inserted a manual page break at the end of each line. I'd like to remove those w/out having to do it "by hand." Any... |
|
| Remove line breaks hello, i have a document that has a lot of line breaks that i would like to remove, so that the text will fill up each line. i am using word 2003. i've looked for a way to... |
|
| Remove line breaks Hi, I have received a file that has a lot of rows in one cell. These are made by using line break (ALT+ENTER). How can I get these rows so that each one is in their own... |
|
|
All times are GMT. The time now is 03:03 PM. | Privacy Policy
|
How do I remove line breaks in Excel cells?