Since an asterisk (*) is a wildcard, when you attempt to perform a find and
replace operation to find all * and replace it with another character, excel
will find everything, not just the asterisk characters.

In order to find these special characters, you need to add a tilde (~) in
front of the special character.

For example, to find all asterisks, input this into the find box:

~*

The tilde is located above the Tab key.

If you wanted to find and replace tilde characters, then you would enter:

HTH,
Paul



--

"leo" wrote in message
...
I have lot of * along with other data. How can i replace * with blanks