Thanks --- Learn something new every day!!!!
--
Perry K


"Mike H" wrote:

Hi,

Excel will treat * as a wildcard so use ~* in the 'Find What' field to make
it treat * as a literal character.

Mike

"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
--
Perry K