2024年1月14日发(作者：)

1. Select all cells in column

C and press Ctrl + C to copy the data to clipboard.2. Now pick the cell B2 and press the Shift + F10 shortcut. Then just press V.3. Remove the helper macro to get rid of line breaksPros: Being created once, can be reused in any : you need to have the basic knowledge of VBA macro from the example below deletes carriage returns from all cells in the currently opened worksheet (activeworksheet).Sub RemoveCarriageReturns() Dim MyRange As Range Updating = False ation = xlCalculationManual

For Each MyRange In nge If 0 < InStr(MyRange, Chr(10)) Then MyRange = Replace(MyRange, Chr(10), "" ) End If Next

Updating = True ation = xlCalculationAutomaticEnd SubIf you don't know VBA really well, see