Results 1 to 9 of 9

Find the corresponding numbers for English letters separately

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-02-2021
    Location
    Thailand
    MS-Off Ver
    365
    Posts
    190

    Find the corresponding numbers for English letters separately

    example
    Cell A5 is AAB, 1+1=2=4, answer is 4
    Cell A9 is EE, 5+5=10, answer is 10

    Can someone please help me ? It would be much appreciated. Thanks in advance
    Attached Files Attached Files
    Last edited by choletseng; 04-29-2024 at 08:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA - to find the highest letter, mix with letters and numbers.
    By TAllan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-02-2021, 03:58 PM
  2. [SOLVED] Counting letters and numbers separately in a single cell
    By ss2012 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-27-2019, 06:22 PM
  3. Selecting letters/characters/numbers separately for a filter
    By WasWodge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2014, 09:12 PM
  4. Replies: 13
    Last Post: 06-20-2014, 01:52 PM
  5. [SOLVED] Find and Delete all letters & leave numbers
    By Patish in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-06-2013, 08:11 AM
  6. Find all possible combinations of letters and numbers
    By grifter_1229 in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 09-15-2010, 08:09 AM
  7. Translating letters from english to russian
    By Suleyman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2006, 09:41 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