how can I delete "*" formated as text

[PerryK]

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

 

[Ron Rosenfeld]

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

 

[Mike H]

Hi,

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

Mike

 

[PerryK]

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

 

[PerryK]

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

 

[Dave Peterson]

Some more info...

Excel can use wildcards in some functions and operations (edit|find, for
example).

* for any characters
? for any single character
~ as an "escape" character to indicate that the next * or ? should be treated as
an asterisk or question mark--not as wild cards.

So to find an asterisk, you use: ~*
to find a question mark, you use: ~?
to find a tilde, you use: ~~