string:Text to value

[pantelis]

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!!!!!!!

[Marcelo]

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!!!!!!!
>
>
>

[pantelis]

thx alot man, that was great help



"Marcelo" <[email protected]> wrote in message
news:[email protected]...
> 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!!!!!!!
> >
> >
> >

[Marcelo]

thanks for the feedback
regards


"pantelis" escreveu:

> thx alot man, that was great help
>
>
>
> "Marcelo" <[email protected]> wrote in message
> news:[email protected]...
> > 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!!!!!!!
> > >
> > >
> > >
>
>
>