Remove the paragraph space.

i have typed 2-3 lines in a cell using Alt+Enter.

How I can remove this paragraph space as there are many cells like this.

Please help.

Thanks in anticipation.

s karan

open the Visual Basic Editor and add the macro below to a code module.
Select the cells where you wish to remove the Alt+Enter
execute the macro

Sub ReplaceSelection()

    Dim xlCell As Range

    For Each xlCell In Selection
        MsgBox xlCell.Text
        xlCell = Replace(xlCell.Text, Chr(10), " ")
    Next xlCell
    
End Sub