jods

Have exported data from Lotus Notes database.
2000 + lines of data and 32 columns.

All data has unprintable character at end of it !

Need to clean it out


' This bit successfully clears the null data that I don't want
Set myRange = ActiveCell.CurrentRegion
myRange.Select
Selection.Replace What:="", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

'I want this bit to kill non-printing characters but it is misbehaving

myRange.Select
Selection.Clean

Any VB gurus out there

Crispin

first of all whats the culprit char??

get the ascii value of the char - by doing something like this (you probably knew this anyway)


Dim s As String
s = "lnmlJkljnkljnlkjNJKLN" & Chr(0)
Debug.Print Asc(Right$(s, 1))