Search This Blog

pCloud Crypto

CODE formula in Excel with examples

The CODE function in Excel returns the numeric code for a given character. Let’s explore some examples:

  1. Finding the Code for a Character:

    • To get the code for the letter “a”, use:
      =CODE("a")  // Returns 97
      
    • If you have the character “a” in cell A1, the formula below gives the same result:
      =CODE(A1)  // Also returns 97
      
  2. Using CODE to Find Character Codes:

    • Suppose you have data with characters like “A”, “a”, “0”, and “-11”. To find their codes, use:
      =CODE("Anand")  // Returns 65 (code for character 'A')
      =CODE("An")     // Also returns 65
      

Remember that the CODE function provides the code for the first character only in the given string. Happy Excel coding!

No comments:

Post a Comment

pCloud Lifetime

The customer care and complaint management contact details for BASIC Bank Limited

If you need to get in touch with  BASIC Bank Limited  in Bangladesh regarding complaints or suggestions, here are the ways you can reach the...