| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion to Text file format error | Excel Discussion (Misc queries) | |||
| extra help with transpose | Excel Discussion (Misc queries) | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
