If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
ignoring text data in a cell when summing values in the same cell
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? |
#3
|
|||
|
|||
ignoring text data in a cell when summing values in the same cell
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 |
Thread Tools | |
Display Modes | |
|
|