View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default Remove * from value

Is there anyway using find and replace if I have a number and then an *.
Example 5* How can I replace the '*' from the field so that the formula
MAX will work. Any way please. Thanks