+ Reply to Thread
Results 1 to 5 of 5

Value of Letters in Word

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    U.S
    MS-Off Ver
    Microsoft Office 2010
    Posts
    2

    Value of Letters in Word

    I am looking to assign values to each letter in the alphabet and then have a formula calculate the value of the word. For example, A=1, B=2, C=3, etc. Then have a formula calculate the value of a word like "acceptable" (which should be 68). Assigning the values to the letters is simple enough, it is the calculation of the value of the word I am stuck on.

    Any help is appreciated.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,000

    Re: Value of Letters in Word

    Please Login or Register  to view this content.
    data in A1

    in B1

    =letter_count(A1)

  3. #3
    Registered User
    Join Date
    09-03-2014
    Location
    U.S
    MS-Off Ver
    Microsoft Office 2010
    Posts
    2

    Re: Value of Letters in Word

    Excellent! Thanks!

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,000

    Re: Value of Letters in Word

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Value of Letters in Word

    Another option using a formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This needs to be confirmed with Ctrl Shift Enter, rather than just Enter

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 09-01-2020, 10:49 AM
  2. Word 2010 - Word Makes First Letters Of First Words Capitalized
    By zanshin777 in forum Word Formatting & General
    Replies: 0
    Last Post: 09-10-2019, 05:35 PM
  3. VBA: Scramble the letters within a word
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-21-2016, 10:23 AM
  4. Extract the letters after a word
    By cmb80 in forum Excel General
    Replies: 10
    Last Post: 08-12-2015, 10:05 AM
  5. Possible to display the 1st 5 letters of a word??
    By jasonmcbride in forum Excel General
    Replies: 7
    Last Post: 11-13-2008, 06:30 PM
  6. split word into letters
    By rogerthat12345 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2007, 05:53 PM
  7. Letters In A Word
    By djfatboyfats in forum Excel General
    Replies: 5
    Last Post: 07-18-2007, 10:19 AM

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