Excluding Text combined with numerical value in EXCEL 2003

  • Thread starter Thread starter MW
  • Start date Start date
M

MW

I have a column of numbers of which some have an * in front. When doing
AutoSum it excludes these values which I want to keep. How do I create a
formula to recognize the values but exclude the text. Thanks
MW
 
Back
Top