View original (French)

Extract a letter from a specific position

Solved
sebii -  
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 Contributor
    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
    1. 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 Contributor
        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 Contributor
        No problem
        I consider the issue resolved
        Safe travels
        regards
        0