• notice
  • Congratulations on the launch of the Sought Tech site

How to quickly delete "line breaks" in Excel cells in batches

Method a: Wrap canceled
in Excel cell linefeed Alt + Enter shortcut keys, the cell was set to "wrap", if you want to "wrap" the effect of these cells to cancel, and Just delete the "line break", the method is as follows:
1.Excel 2003 operation method: select the cells that need to be adjusted, right-click the mouse, and select "Format Cells" in the pop-up shortcut menu, and then click the "Alignment" tab You can see that the "Auto-wrap" option has been selected, cancel this option and click "OK".
2.The operation method of Excel 2007 and above: first select these cells, then select the "Start" tab in the functional area, and click the "Wrap" button in the "Alignment" group.
But this method has a disadvantage.When these cells are selected, the content in the formula bar is still line-wrapped, and double-clicking the cell will automatically change to "automatic line-wrap".

Method 2: Find and Replace
Step1: Press the shortcut key Ctrl+H to open the "Find and Replace" dialog box;
Step2: Select the text box behind the "Find Content", hold down the Alt key, and enter "0010" in the numeric keyboard. It should be noted that after entering this way, nothing will be displayed in the text box after "Find Content", but there is actually;
Step3: Click the "Replace All" button, and the line breaks will be replaced.

Method 3: Use CLEAN function
CLEAN function can delete characters that cannot be printed in the text. If cell A1 contains a line break, you can enter the formula in cell B1: "=CLEAN(A1)" to delete the line break.


Technical otaku

Sought technology together

Related Topic


Leave a Reply