Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Assigning Numerical Values in Letters

  1. #1
    Join Date
    31st March 2013
    Posts
    2

    Assigning Numerical Values in Letters

    Is it possible once you have assigned letter a numerical value (example: A = 1, B = 2) add them together?
    (example: AB = 3)

    Here is the file what i trying to do

    If it is possible, it would help me a fortune
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,921

    Re: Assigning Numerical Values in Letters

    Perhaps if you explain this in context... but maybe

    VB:
     
    Sub x() 
         
        Dim a As Integer 
        Dim b As Integer 
         
        a = 2 
        b = 1 
         
        MsgBox a + b & "project.xls" 
         
    End Sub 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    31st March 2013
    Posts
    2

    Re: Assigning Numerical Values in Letters

    Dear cytop,

    First of all im very great full for ur reply but this is not im trying to do, didn't you cheek the attach file, this is for my project, i did try but wasn't successful.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    1st September 2010
    Posts
    7,921

    Re: Assigning Numerical Values in Letters

    ...didn't you cheek the attach file
    No, I didn't check the file... not for any reason other than I'm using an Android Pad at the moment.

    You'll generally find you'll get more timely, and more accurate, replies when you describe your issue in your post. Some users can't, and some are unwilling, to download files. Even if I was using a Windows machine, I don't generally go to the bother of downloading a file, running it through a virus checker (no offence - it's just a sensible thing to do), opening it in Excel to view/read your problem only to find I can't help.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    19th August 2009
    Location
    Brisbane, Australia
    Posts
    192

    Re: Assigning Numerical Values in Letters

    Using a lookup range it can be done - see attached.

    I used a column down to 255 rows (you can use less if you know your word length is less).
    Lookup the Nth character (based on Nth row) and return the value of that character from the hlookup table.
    Then add up the lookup column.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    19th July 2004
    Location
    Tokyo, Japan
    Posts
    8,506

    Re: Assigning Numerical Values in Letters

    VBA

    To Sheet1 code module
    VB:
    Private Sub Worksheet_Change(ByVal Target As Range) 
        Dim i As Long 
        With Target 
            If .Address(0, 0) = "B4" Then 
                Application.EnableEvents = False 
                .Offset(, -1).ClearContents 
                If Not .Value Like "*[!a-z]*" Then 
                    For i = 1 To Len(.Value) 
                        .Offset(, -1).Value = .Offset(, -1).Value + _ 
                        Application.HLookup(Mid$(.Value, i, 1), Range("b2:aa3"), 2, True) 
                    Next 
                End If 
                Application.EnableEvents = True 
            End If 
        End With 
    End Sub 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 1
    Last Post: September 8th, 2012, 15:38
  2. Assigning a numerical value to a letter
    By mack72 in forum EXCEL HELP
    Replies: 3
    Last Post: November 8th, 2011, 19:47
  3. Assigning Variable Values To Letters In A Table
    By Upside in forum EXCEL HELP
    Replies: 4
    Last Post: July 20th, 2007, 23:00
  4. Applying Numerical Values To Letters In Formula
    By yodaman in forum EXCEL HELP
    Replies: 3
    Last Post: February 28th, 2007, 16:31
  5. Assigning text numerical values?
    By P-Towner in forum EXCEL HELP
    Replies: 12
    Last Post: July 11th, 2006, 09:40

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
  •  
porno