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

  • Thread starter Thread starter FM
  • Start date Start date
F

FM

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?
 
Much, much easier never to mix text & numbers in the same cell in the 1st
place. One avenue here, try use Data>Text 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
 
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?
 
Back
Top