Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I remove a constant from a cell?
I have a spreadsheet that has been updated and now sent to me for formatting
and formula auditing but along the way someone entered in a constant variable that is not needed but is preventing my actual calculations from showing. Can anyone offer any insight on how I can remove these non needed constants? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I remove a constant from a cell?
What is a 'constant variable'?
I think you need to divulge more information or give more details about the issue. Just a random thought here, but you may try something like this: =SUBSTITUTE(A1,"-","") That would get rid or all '-' characters in a cell. If, for instance, you wanted to find everything to the left of a certain character (maybe a constant variable), such as the letter 'a', you could try a function like this: =LEFT(A1,FIND("a",A1)-1) Hope that helps you a bit. Regards, Ryan-- -- RyGuy "ac" wrote: I have a spreadsheet that has been updated and now sent to me for formatting and formula auditing but along the way someone entered in a constant variable that is not needed but is preventing my actual calculations from showing. Can anyone offer any insight on how I can remove these non needed constants? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I remove a constant from a cell?
Ryan,
Thanks! When I hit formula auditing that is what showed up: constant variable. It is kind of "hiding" the 1 for now and letting me input different numbers. Thanks again! What is a 'constant variable'? I think you need to divulge more information or give more details about the issue. Just a random thought here, but you may try something like this: =SUBSTITUTE(A1,"-","") That would get rid or all '-' characters in a cell. If, for instance, you wanted to find everything to the left of a certain character (maybe a constant variable), such as the letter 'a', you could try a function like this: =LEFT(A1,FIND("a",A1)-1) Hope that helps you a bit. Regards, Ryan-- -- RyGuy "ac" wrote: I have a spreadsheet that has been updated and now sent to me for formatting and formula auditing but along the way someone entered in a constant variable that is not needed but is preventing my actual calculations from showing. Can anyone offer any insight on how I can remove these non needed constants? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to set a cell value to be constant in formulas? | Excel Worksheet Functions | |||
Constant cell | Excel Worksheet Functions | |||
How do I remove a constant from an excel spreadsheet? | Excel Discussion (Misc queries) | |||
How do I remove a constant from an excel spreadsheet? | Excel Discussion (Misc queries) | |||
the cell currently being evaluated contains a constant | Excel Worksheet Functions |