how to remove carriage returns from string

[damon2003]

Hi,
I am storing strings from a access database into variables. However in some of the fields in the database, there are carriage return symbols, at least I think they are. They are small recangular blocks. Is there any way I can remove these from the variables. I have tried the following
strAmended = replace(strText, chr(9), "")
strAmended = replace(strText, chr(10), "")
strAmended = replace(strText, chr(13), "")
strAmended = replace(strText, """", "")

strAmended = replace(strText, vbCrLf, "")
strAmended = replace(strText, vbCr, "")
strAmended = replace(strText, " ", "")

but it doesnt seem to work,

any other ideas?
thanks

ps the data was imported into access from excel