Much, much easier never to mix text & numbers in the same cell in the 1st
place. One avenue here, try use DataText to Columns to split the numbers
separate from the text, then you can sum (or whatever) the numbers col
directly.
Or, assuming your data is representative (ie numbers are to the left of the
dash "-") and runs in A2 down, you could place this in B2:
=LEFT(A2,SEARCH("-",A2)-1)+0
and copy down, then SUM col B
Any joy? hit YES to wave it
--
Max
Singapore
---
"FM" wrote:
I have entered text in cells along with a numerical value as a note pertainig
to the values example, "2 - exist". Is there a way to tell Excell to ignore
the text data in order to sum the values..do you place the text in brackets
or parenthesis or something similar?