Assuming the * are in cells by themselves.

EditReplace

what: ~*

with: nothing

Make sure options are set to "Match whole cell contents"

Replace all.


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 15:00:15 -0800, leo
wrote:

I have lot of * along with other data. How can i replace * with blanks