Text to value
 

Hi all, would appreciate some help

I've got the following string

"week"&RIGHT(A6,2)&"move99.5" which looks something like this
"week05move99.5"

I have defined the name (week05move99.5 to equal 500) so basically when I
type in (week05move99.5) I want to see 500.

now because "week"&RIGHT(A6,2)&"move99.5" = "week05move99.5" which is a Text
string I dont get any value.

I have tried VALUE ("week"&RIGHT(A6,2)&"move99.5") but I get #VALUE!

Has anyone got any good ideas.

thx!!!!!!!

Text to value
 

hi Pantelis,

use = indirect("week"&RIGHT(A6,2)&"move99.5")

hth
regards from Brazil
Marcelo

"pantelis" escreveu:

Hi all, would appreciate some help

I've got the following string

"week"&RIGHT(A6,2)&"move99.5" which looks something like this
"week05move99.5"

I have defined the name (week05move99.5 to equal 500) so basically when I
type in (week05move99.5) I want to see 500.

now because "week"&RIGHT(A6,2)&"move99.5" = "week05move99.5" which is a Text
string I dont get any value.

I have tried VALUE ("week"&RIGHT(A6,2)&"move99.5") but I get #VALUE!

Has anyone got any good ideas.

thx!!!!!!!

Text to value
 

thx alot man, that was great help



"Marcelo" wrote in message
...
hi Pantelis,

use = indirect("week"&RIGHT(A6,2)&"move99.5")

hth
regards from Brazil
Marcelo

"pantelis" escreveu:

Hi all, would appreciate some help

I've got the following string

"week"&RIGHT(A6,2)&"move99.5" which looks something like this
"week05move99.5"

I have defined the name (week05move99.5 to equal 500) so basically when
I
type in (week05move99.5) I want to see 500.

now because "week"&RIGHT(A6,2)&"move99.5" = "week05move99.5" which is a
Text
string I dont get any value.

I have tried VALUE ("week"&RIGHT(A6,2)&"move99.5") but I get #VALUE!

Has anyone got any good ideas.

thx!!!!!!!

Text to value
 

thanks for the feedback
regards


"pantelis" escreveu:

thx alot man, that was great help



"Marcelo" wrote in message
...
hi Pantelis,

use = indirect("week"&RIGHT(A6,2)&"move99.5")

hth
regards from Brazil
Marcelo

"pantelis" escreveu:

Hi all, would appreciate some help

I've got the following string

"week"&RIGHT(A6,2)&"move99.5" which looks something like this
"week05move99.5"

I have defined the name (week05move99.5 to equal 500) so basically when
I
type in (week05move99.5) I want to see 500.

now because "week"&RIGHT(A6,2)&"move99.5" = "week05move99.5" which is a
Text
string I dont get any value.

I have tried VALUE ("week"&RIGHT(A6,2)&"move99.5") but I get #VALUE!

Has anyone got any good ideas.

thx!!!!!!!