Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old April 29th 08, 03:08 PM posted to microsoft.public.excel.worksheet.functions
ac ac is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 18
Default 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   Report Post  
Old April 29th 08, 03:31 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 2,836
Default 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   Report Post  
Old April 29th 08, 07:48 PM posted to microsoft.public.excel.worksheet.functions
ac ac is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 18
Default 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
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to set a cell value to be constant in formulas? Marshall Excel Worksheet Functions 4 November 2nd 07 04:29 PM
Constant cell Aurora Excel Worksheet Functions 1 February 14th 06 03:08 PM
How do I remove a constant from an excel spreadsheet? rugby1021 Excel Discussion (Misc queries) 2 January 20th 06 06:07 PM
How do I remove a constant from an excel spreadsheet? rugby1021 Excel Discussion (Misc queries) 0 January 19th 06 08:50 PM
the cell currently being evaluated contains a constant Barrie Wells Excel Worksheet Functions 2 June 2nd 05 12:59 PM


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017