B
Blah
Hello, I need to find numbers with an asterisk after them...but excel
keeps treating it as a wild card character...anyway to stop this?
keeps treating it as a wild card character...anyway to stop this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
kkjkljj*
formula
=FIND("*",B7)
sub
MsgBox InStr(ActiveCell.Value, "*")
formula
=FIND("*",B7)
sub
MsgBox InStr(ActiveCell.Value, "*")
G
Guest
You could make a column and try this formula, put the actual cell reference
in the fomula where your numbers start, then copy this down the column.
=IF(RIGHT(A1,1)="*","Asterisk Here!","No Asterisk!")
in the fomula where your numbers start, then copy this down the column.
=IF(RIGHT(A1,1)="*","Asterisk Here!","No Asterisk!")
D
Dave Peterson
Edit|Find
search for ~*
(tilde asterisk)
search for ~*
(tilde asterisk)
Hello, I need to find numbers with an asterisk after them...but excel
keeps treating it as a wild card character...anyway to stop this?
B
Blah
Yeah but I have to replace them to so its irritating not being able to
use the replace all function. Any good formula for that?
use the replace all function. Any good formula for that?