remove a part of a cell

[BTR]

I have a long series of numbers which contains the asterisk symbol (*). How
can I remove this symbol from these many numbers?

 

[Bob I]

Click Edit, Replace. leave "replace with" blank

 

[David Biddulph]

What you forgot to say, Bob, was that the "Find what" should be ~*, in other
words a tilde in front of the asterisk.

 

[BTR]

PERFECT!!!

Thanks for the help

 

[Bob I]

thanks

What you forgot to say, Bob, was that the "Find what" should be ~*, in other
words a tilde in front of the asterisk.