Finding an 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?

kkjkljj*

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

--
Don Guillett
SalesAid Software
[email protected]
"Blah" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>

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

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?