View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default remove a part of a cell

Click Edit, Replace. leave "replace with" blank

BTR wrote:

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