On Thu, 2 Apr 2009 06:20:01 -0700, PerryK
wrote:

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks

The tilde tells Excel to treat the asterisk as a literal.

So in your Find what: string you would enter: ~*
--ron