ExcelMonkey,

Use Edit |Replace... For "Find what" use

~**

and leave "Replace with" blank.

HTH,
Bernie
MS Excel MVP

"ExcelMonkey" wrote in message
...
Not sure if this is the right forum for this. I want to
do a Find/Replace in Excel. I want to Replace everything
after the first asterisk in each cell.

For Example:
170*(A34-A33)

would then look like
170

How do you search on * and everything that comes after it?

Thanks