[RESOLVED] removing of special characters

[mariyana]

We display an expression in excel , in which there are also some small boxes being diaplayed in expression.

somes boxes are getting removed when we give
replace(string1,vbnewline,"")
but some are not.

Are there any other keywords like vbnewline which displays small boxes, which when given will remove the small boxes

[Spajeoly]

Excel uses Chr(10) normally, but remove 10 & 13 individually.

String = Replace(String, Chr(10), "")
String = Replace(String, Chr(13), "")

[mariyana]

like vbnewline is there any keyword for space since found that small box is representing space or ascii value for space

[robbedaya]

To know the ascii value of a space:

msgbox asc(" ")

Spaces would not be represented a little box. It must be another character.

[mariyana]

Yes it was due to space but the non-printable character was due to tab . The problem is now solved by giving

replace(string1,vbtab,"")

Thanks