Clear a Carriage Return from a String Value
Hi,
The CLEAN worksheet function removes all non printable characters, try
something like this
Sub CarriageRtn()
Dim cell As Range
For Each cell In Selection
cell.Value = Application.WorksheetFunction.Clean(cell.Value)
Next cell
End Sub
Select the problem cells and run the macro
|