Removing all text except numbers and letters

I'm having trouble with a script i wrote which copies a value from one place to another. The problem is that when it copies, it copies a wierd character which is shown by a square with a questionmark inside followed by the correct text, like so:
"?results"
What i want to do is remove that character and leave make the cell only have "results" in it.
Anyone know how i can do this?
Thanks a lot.

Welcome.
If we could see your code, it would be easier to make a suggestion.

try
=myClean(A1)

Please Login or Register  to view this content.

Originally Posted by mikerickson

Welcome.
If we could see your code, it would be easier to make a suggestion.

I'm currently in the process of writing it.
All i'm trying to do is remove the weird, incorrect code that is being copied, and leaving the normal characters that are pasted

try
=myClean(A1)
Code:

Function myClean(txt As String) With CreateObject("VBScript.RegExp") .Pattern = "[\f\n\r\t\v]+" .Global = True myClean = Trim(.replace(txt,"")) End With End Function

Im a noob when it comes to excel and scripting, how would i apply this to the code?

1) hit Alt + F11 to open vb editor
2) go to [Insert] - [Module] then paste the code onto the right pane
3) hit Alt + F11 to get back to Excel

Used in cell

=myClean(A1)

Have you tried =CLEAN(A1)?

Originally Posted by jindon

1) hit Alt + F11 to open vb editor
2) go to [Insert] - [Module] then paste the code onto the right pane
3) hit Alt + F11 to get back to Excel

Used in cell

=myClean(A1)

Thanks a lot! It worked perfectly