+ Reply to Thread
Results 1 to 6 of 6

Convert alpha-numeric to numeric

  1. #1
    Registered User
    Join Date
    04-24-2008
    Posts
    4

    Convert alpha-numeric to numeric

    Hi,

    Does anyone know of a way to convert alpha-numeric text to numeric text? E.g. I want to be able to convert 2a (which is in one column) to the value 17 (in another column)

    Many thanks,

    Michaelmac

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    How is 2a equivalent to 17?

  3. #3
    Registered User
    Join Date
    04-24-2008
    Posts
    4

    Thumbs up Converting alpha-numeric to numeric only

    Thank tyou for your reponse. I'll do my best to explain my problem:

    The Government has (until now) asked teachers to report pupils' attainment in nation SATs in the form of an alpha-numeric number, thus:

    1c, 1b,1a, 2c, 2b, 2a, 3c, 3b, 3a, 4c, 4b, 4a, 5c, 5b, 5a

    Now they want us to report that information in another form, too - as a number only, which they call an 'average points score (APS).' The alpha-numeric levels are already embedded into teachers' assessment methods, but these cannot be used for statistical analyses as easily as numbers. So, we now need both forms of reporting. We want to be able to type in the alpha-numeric and have an aps number returned in another column.

    For example, the equivalents are:

    1c= 7, 1b=9, 1a=11, 2c=13, 2b=15, 2a =17, 3c=19, 3b=21, 3a=23, 4=25c, 4b=27, 4a=29, 5c=31, 5b=33, 5a=35

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    Try:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-24-2008
    Posts
    4

    Thumbs up Alpha-numeric to numeric

    Dear Darkyam,

    Many, many thanks for your prompt response. I will try your suggestion. You could be a life-saver!
    Best wishes,

    Mike

  6. #6
    Registered User
    Join Date
    04-24-2008
    Posts
    4

    Thumbs up Alpha-numeric to numeric

    Dear Darkyam,

    Your piece of code worked a treat! Thank you.

    Mike

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1