Macro to remove <enter> in an address line

[MarkSpencer]

I have a CSV file that has data exported that includes addresses. If the address line had a second row, it is all in one cell with a special character at the end of the first row of data. I am trying to record a macro to remove the special character. I put the cursor in the cell that needs editing, then do the following:

Start Recording
Press "Use Relative References" (because I want to just go down the list and do this for each line that needs it)

Then for the macro, I perform the following steps:
Press F2 to edit the cell
Press Ctrl+Home to go to top left corner of cell
Press End to go to end of the first line
Press Backspace to delete the special character.
Press Space to insert one space
Press Delete to bring the second line up to the first line
Prese Enter to exit editing and move down.

Press Stop Recording

My problem is that when I try to run the macro on the next cells, it simply pastes the value from the cell that it was on when I recorded the macro.

What am I doing wrong?

 

[VoG]

Try selecting the range then running this

Sub RemLF()
Dim c As Range
For Each c In Selection
    c.Value = Replace(c.Value, vbLf, " ")
Next c
End Sub

 

[MarkSpencer]

That brought the second line up to the end of the first, but the special character (it is a question mark inside a rectangle) still shows and prints.

 

[VoG]

In the code try replacing VBLf with vbCr. If that still doesn't work try vbCrLf

 

[MarkSpencer]

vbCrLf worked as needed.

vbCr removed the special character but left the data on two rows.

THANK YOU so much for your help and quick response!