VBA: How to delete paragraph marker

[NeoSez]

There is a date dd/mm/yyyy and then a new paragraph after it. I tried to remove it many ways and was unsuccessful. Can someone provide a VBA code to remove the space or new paragraph, under that one column? The date should have no spaces before or after. Thank you.

 

[Michael M]

Maybe this, which will remove para s and spaces
Select the range of cells then run the code

Sub MM1()
    Dim xChars As String
    Dim I As Long, cell As Range
    xChars = "¶ "
    For Each cell In Selection
    For I = 1 To Len(xChars)
        cell = Replace(cell, Mid(xChars, I, 1), "")
    Next I
    Next cell
End Sub

 

[Michael M]

Do you realise you can do this without the code.....
Highlight the column>>EditingTab>>Find>>Replace>> In the find box, Hold down the ALT key and, using the numberpad, type 0182 Leave the replace box blank>> OK

 

[NeoSez]

Thank you Michael M

 

[Michael M]

Glad to help