Reading a text string charachter by charachter....convert string to number

  • Thread starter Thread starter ChuckM
  • Start date Start date
C

ChuckM

I have a text string that contains an age range...:

text_string(1)= 6 - 10
text_string(2) = 11 - 13
text_string(3) = 14 +


I also have an age variable (integer) that I need to assign to an age
group.

e.g.

age = 12
so I need to map this to text_variable(2).

I believe that I can do this if I can read eaxh charachter of the
string...if someone can tell me how to do this.... or is there an
easier way?

Thanks
ChuckM
 
I'm not sure exactly what you are trying to do but if you
need to interrogate the text within a cell lookup these
worksheet functions in help:
Left
Right
Mid
Search

One or more of them may provide your solution.
 
Hi Chuck,
If the text 6 - 11 is in B2 then the formula =LEFT(B2,LEN(B2)-FIND("-",B2))
will give you the 6 as a number.
Any help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a micron symbol to text string 5
Formating a string to fit the page 1
Mapping strings to integers 5
Can I insert 'carriage/line returns' in text string? 1
Help! IF functions 3
Searching the formula (not the value) for a text string 1
Forumla to count the number that fall betwee 13-25 in a column 2
Excel - Fill empty cells 3

Back
Top