Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
treat text as blank
is there a way to have text in a spreadsheet treated as blank - I paste in
yachting elapsed times to do some calculations but the cells with DNC cause problms. Can i run a formula to treat or convert them to blank fields? -- PT |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
treat text as blank
You can test the cells within your formula with ISTEXT or ISNUMBER to avoid
the errors... we can help more if you can share the formula you are trying to use... "Reggie1000" wrote: is there a way to have text in a spreadsheet treated as blank - I paste in yachting elapsed times to do some calculations but the cells with DNC cause problms. Can i run a formula to treat or convert them to blank fields? -- PT |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
treat text as blank
Maybe the formula that uses those cells should be changed.
Instead of: =a1+a2+a3 you could use: =sum(a1:a3) =sum() will ignore text. Or if you wanted to treat the text as 0's, you could use something like: =n(a1)+n(a2)+n(a3) Reggie1000 wrote: is there a way to have text in a spreadsheet treated as blank - I paste in yachting elapsed times to do some calculations but the cells with DNC cause problms. Can i run a formula to treat or convert them to blank fields? -- PT -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to treat e-mail addy as text! | Excel Discussion (Misc queries) | |||
Function to treat formula result as blank cell | Excel Worksheet Functions | |||
Force Excel To Treat A Cell As Blank | Excel Worksheet Functions | |||
Lookup formula - treat no-registered cells as blank | Excel Worksheet Functions | |||
Find&Replace * - Is it possible to treat * as text and not wildcar | Excel Discussion (Misc queries) |