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
dguillett1@austin.rr.com
"Blah" <cidster12@yahoo.com> wrote in message
news:1148084864.182570.252060@j33g2000cwa.googlegroups.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?
>
>

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?