Tags: along, auditing, cell, constant, entered, excel, formatting, formula, microsoft, msdn, software, spreadsheet, updated

How can I remove a constant from a cell?

On Microsoft » Microsoft Excel

2,553 words with 2 Comments; publish: Fri, 23 May 2008 09:38:00 GMT; (30631.25, « »)

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?

All Comments

Leave a comment...

  • 2 Comments
    • 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?

      #1; Fri, 23 May 2008 09:39:00 GMT
    • 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?

      #2; Fri, 23 May 2008 09:40:00 GMT