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?

kkjkljj*

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

--
Don Guillett
SalesAid Software

"Blah" wrote in message
oups.com...
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?

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

"Blah" wrote:

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?

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?

Edit|Find
search for ~*
(tilde asterisk)

Blah wrote:

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?

--

Dave Peterson