View original (French)

Excel: extract the text after a character.

Solved
lolo5476 -  
 Pat45 -
Hello,

How to extract the letters to the right of these cells after T41.
Knowing that the number of letters after T41 varies between 3 and 5.
WREUCT41SIAC
WREUCT41SIAHM
WPRT41EZY

So it doesn't work 
=RIGHT(A1,LEN(A1)-FIND("T41",A1,FIND("T41",A1)+1)) =RIGHT(A1,LEN(A1)-SEARCH("T41",A1,3))


Thank you.
I bet on chocolate that I would find it, but I've been at it for 30 minutes already.

3 answers

Answer 1 / 3
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Hello,

How to extract the letters to the right of these cells after T41.
Knowing that the number of letters after T41 varies between 3 and 5.
WREUCT41SIAC
WREUCT41SIAHM
WPRT41EZY

So it doesn't work 
=RIGHT(A1,LEN(A1)-FIND("T41",A1,FIND("T41",A1)+1)) =RIGHT(A1,LEN(A1)-SEARCH("T41",A1,3))


Thank you.
I bet on chocolate that I would find it, but I've been at it for 30 minutes already.
25
Tojo
 
Hello,

How to extract the letters to the right of these cells after T41.
Knowing that the number of letters after T41 varies between 3 and 5.
WREUCT41SIAC
WREUCT41SIAHM
WPRT41EZY


So it doesn't work 
=RIGHT(A1,LEN(A1)-FIND("T41",A1,FIND("T41",A1)+1)) =RIGHT(A1,LEN(A1)-SEARCH("T41",A1,3))


Thank you.
I bet on chocolate that I would find it, but I've been at it for 30 minutes already.
0
Pat45
 
Hello,

How to extract the letters to the right of these cells after T41.
Knowing that the number of letters after T41 varies between 3 and 5.
WREUCT41SIAC
WREUCT41SIAHM
WPRT41EZY


So it doesn't work 
=RIGHT(A1,LEN(A1)-FIND("T41",A1,FIND("T41",A1)+1)) =RIGHT(A1,LEN(A1)-SEARCH("T41",A1,3))


Thank you.
I bet on chocolate that I would find it, but I've been at it for 30 minutes already.
0