This did not work for me, when I returned to the excel sheet all the columns had been jumbled up.
However I managed to find another solution with one line of VBA:
Worksheets("Sheet1").Columns("I").Replace What:=vbCrLf, Replacement:="?"
Should be self explanatory, the vbCrLf is the VB code for a carriage return and just replace the ? with whatever you want in place of the carriage return.
Brian
However I managed to find another solution with one line of VBA:
Worksheets("Sheet1").Columns("I").Replace What:=vbCrLf, Replacement:="?"
Should be self explanatory, the vbCrLf is the VB code for a carriage return and just replace the ? with whatever you want in place of the carriage return.
Brian