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

Answer 1 / 2
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
Answer 2 / 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
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
sebii
 
Thank you Vaucluse, it works perfectly!
0
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
No problem
I consider the issue resolved
Safe travels
regards
0