ignoring text data in a cell when summing values in the same cell

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 parathesis or something similar?
--
FM

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?

2 - exist

Does every cell follow that same format? A number followed by a space
followed by a dash?

Does every cell contain a number?

--
Biff
Microsoft Excel MVP


"FM" wrote in message
...
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 parathesis or something similar?
--
FM