How to find and replace a "*" character in a cell without deleting the entire contents in Excel 2010

Question

I have a large spreadsheet with a number of cells containing text that have a "*" character at the end. I would like to find and replace this character and delete it. This solution doesn't seem to work in Excel 2010.

Answer 1

I think you need something like:

=SUBSTITUTE(RANGE,"*","")

You could definitely put a cell range in there, such as:

=SUBSTITUTE(A1:Z2000,"*","")

And I suspect you could put a worksheet name in there?

Answer 2

Use the Replace function by pressing CTRL + H and searching for ~* replacing with a blank.