Hi Tom,

Many times I CSV data from dont know what kind of software and it becomes an
issue to load it in to SPSS. With your generalised solution --You would
replace chr(3) with chr(that number) -- I can programmatically take care of
the cleaning in excel and then upload the data further.

Thnx a lot for CLEAN as well (It works nicely). Wasnt aware of any thing
other than TRIM till now.

Regards,
Hari
India

"Tom Ogilvy" wrote in message
...
That would assume that the character has an ascii code of 3.

You can examine what codes are there with

Sub Checkcode()
Dim sChr As String, sSTr As String
For i = 1 To Len(ActiveCell.Text)
sChr = Mid(ActiveCell.Text, i, 1)
sSTr = sSTr & Asc(sChr) & "-" & sChr & vbNewLine
Next
MsgBox sSTr
End Sub

Note that you probably won't see the small square, but you should see a
number without a printable character next to it. You would replace chr(3)
with chr(that number)

You would could also try the worksheet function CLEAN.

--
Regards,
Tom Ogilvy