ExcelBanter - Excluding Text combined with numerical value in EXCEL 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excluding Text combined with numerical value in EXCEL 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/202183-excluding-text-combined-numerical-value-excel-2003-a.html)

Excluding Text combined with numerical value in EXCEL 2003

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

Gary''s Student

Excluding Text combined with numerical value in EXCEL 2003

In the next column:

=SUBSTITUTE(A1,"*","")+0 and copy down
--
Gary''s Student - gsnu200804

All times are GMT +1. The time now is 03:37 AM.