View original (French)

Extract a letter from a specific position

Solved
sebii -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello everyone,
Being extremely bad at Excel, I'm calling on your expert knowledge :)
I would like to extract a character from a specific position in a string.
Example:
I have 13457689 and I need to find the character at the 5th position, the formula should return 7

Thank you very much in advance for your help.

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    two solutions:

    =MID(A1,5,1)

    or

    =RIGHT(LEFT(A1,5),1)

    note that these results are text. If you want to obtain numeric values, add *1 at the end of the formula after the last parenthesis

    best regards

    The quality of the answer mainly depends on the clarity of the question, thank you!
    0
  2. Sebii
     
    Thank you Vaucluse
    I had seen this formula but the result does not quite correspond to what I am looking for. I specify that I have a cell in A1 with a sequence of 2000 characters that follow each other and I have cells with numbers:
    A1: Azertyazertyazertyazerty...
    B2: 56

    I would like the formula to find which letter corresponds to the number 56 in the string in A1

    Thank you very much!!!
    0
    1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      If it's to find the letter at the specified position in B2:
      =MID(A1,B2,1)
      should do the trick
      ... unless there's a misunderstanding
      0
    2. sebii
       
      Thank you Vaucluse, it works perfectly!
      0
    3. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      No problem
      I consider the issue resolved
      Safe travels
      regards
      0