evaluating a string

I

Imran

hello all

I have a string in a cell as follows

'=10+1+2+3

I have put ' (single quote) to make sure that excel doesnt calculate
the formual. now in the next cell i want
value of this formula, ie 16 (10+1+2+3), can we do this without writing
macros?

Imran
 
N

Niek Otten

Hi Imram,

Insert>Name>Define
For the name, use something like StringValue
Refers To:
=EVALUATE(RIGHT(Sheet1!$A$1,LEN(Sheet1!$A$1)-1))

Now you can use =StringVale in your worksheet and it will evaluate A1 minus the quote

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| hello all
|
| I have a string in a cell as follows
|
| '=10+1+2+3
|
| I have put ' (single quote) to make sure that excel doesnt calculate
| the formual. now in the next cell i want
| value of this formula, ie 16 (10+1+2+3), can we do this without writing
| macros?
|
| Imran
|
|
 
Top