Thread: Question mark character?

Hi JoanneC,
you will find that the are new line markers
"Alt" + "Enter"
which splits data up in a cell into new line within the cell

See here...http://en.wikipedia.org/wiki/Unicode...ment_character

It seems to be an unknown character.. You may need to fix the text in the file before importing into excel

Hi JoanneC
I've used this code in the past to "clean" non-printable characters...see if it works for you. Specify in the code the column(s) you wish to "clean".

Option Explicit
Sub CleanData()
    Dim LR As Long
    Dim i As Long
    Application.ScreenUpdating = False
 
    With ThisWorkbook.ActiveSheet
     LR = Range("A" & Rows.Count).End(xlUp).Row
        For i = 1 To LR
            .Cells(i, 1).Value = Application.Clean(.Cells(i, 1).Value) 'Clean Column A
        Next i
    End With
 
    With ThisWorkbook.ActiveSheet
      LR = Range("B" & Rows.Count).End(xlUp).Row
        For i = 1 To LR
            .Cells(i, 2).Value = Application.Clean(.Cells(i, 1).Value) 'Clean Column B
        Next i
    End With
 
    With ThisWorkbook.ActiveSheet
       LR = Range("C" & Rows.Count).End(xlUp).Row
        For i = 1 To LR
            .Cells(i, 3).Value = Application.Clean(.Cells(i, 1).Value) 'Clean Column C
        Next i
    End With
    Application.ScreenUpdating = True
End Sub