Search and replace Asterisk

[mdjks]

Is there a way to write a function to replace Asterisk "*" without wiping out all characters? I tried using Chr(42) and it still cleared out everything in my selection.

Thanks, any help will be appreciated.

 

[Brianwarnock]

You could use the Substitute function, but this requires you to make a copy
If Sheet1 A1 contained qwe*rty
then in sheet2 A1 =Substitute(Sheet1!a1, "*","M") would return qweMrty in Sheet2 A1.

perhaps you can play with this.
Hope it helps

Brian

 

[qafself]

Hi,

use search and replace - search for ~*
replace with nothing


Check it out

Ed

 

[mdjks]

Thank you both, the ~* works! I tried substitute but couldn't figure out how to nest it, I want to strip out all non alpha characters.

 

[Brianwarnock]

This thread proves you are never too old to learn.

Brian