I have a data set of names (text) and randomly placed throughout the text is the asterisk symbol “*”. See example below. Is there an easy way to delete the asterisk?
I tried the find/replace function but when I tell excel to find the “*” and replace it with nothing, I lose all of my data. It gets deleted and the cells are empty.

Any idea on how I can do this? Thanks you all!

Name:
Mickey *Mouse
*Donald E. Duck
William *Penn
Tom* T Sawyer
Big Willie *Smith