Deleting Asterick in Excel COlumn

[Chris11]

Hello

I have a column with a list of company names. Before each name is an asterick symbol. When I use find/replace it deletes the entire cell. How can I just get rid of the astericks in the column???

Example: *COSTCO
Example: SAFEWAY * INDUSTRIES

[daddylonglegs]

Because * and ? are used as wildcards in excel you need to distinguish between * used as wildcard and a literal *

To do this you add a tilde ( ~ ) in front of the symbol in question, e.g. to use Edit > Replace to eliminate *

Replace ~* with nothing