Finding an asterisk

[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?

 

[Don Guillett]

kkjkljj*

formula
=FIND("*",B7)
sub
MsgBox InStr(ActiveCell.Value, "*")

 

[tim m]

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!")

 

[Dave Peterson]

Edit|Find
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?

 

[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?