Also, for the wildcard characters, from Help,

Wildcard characters
The following wildcard characters can be used as comparison criteria for
filters, and when searching and replacing content.
UseTo find
? (question mark) Any single character
For example, sm?th finds "smith" and "smyth"

* (asterisk) Any number of characters
For example, *east finds "Northeast" and "Southeast"

~ (tilde) followed by ?, *, or ~ A question mark, asterisk, or
tilde
For example, fy91~? finds "fy91?"


HTH,
Bernie
MS Excel MVP

"ExcelMonkey" wrote in message
...
Thanks Bernie. Can you tell me of all the ways to do
searches using Find/Replace (i.e. what type of wild cards
can be used. I really do not understand the syntax and
have to say that I cannot use to its full potential.

For example is possible to do the following:

Find/Replace everything up to X
Find/Replace everything after X
Find/Replace everything up to X and everything after Y
Find/Replade everytning up to first occurence of X and
first occurence of Y
Find multiple occurences of X

Thanks



-----Original Message-----
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


.