Searching for specific characters

[rhino4eva]

i work in an Automated laboratory where i have to move data between two pc controlled machines
One machine will accept "*" (stars not the wildcard symbol), the other wont
i need to search a range b6:b101 for any occurance of " a star " and replace it with a "-"
my trouble is i dont know how to get the macro to recognise i dont wont a wildcard
i have tried chr(42) and "*" to no avail it simply replaces all the column with "-"

 

[Domski]

Have a look here: http://support.microsoft.com/kb/214138

Dom

 

[doofusboy]

Enter this formula into cell C6 and copy down as far as needed:

=SUBSTITUTE(B6,"*","-")

Or, in a macro, this works:

Dim r As Range

For Each r In Range("B6:B101")
r.Value = Replace(r.Value, "*", "-")
Next

 

[Richard Schollar]

Hi

Use the tilde:

Range("A1:G10").Replace "~*", "-"