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

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    for a text in A1 

    =MID(A1;FIND("T41";A1)+3;10)

    the 10 depends on the maximum number of characters you can find after T41, but Excel will only take into account the useful number (unless you have spaces after the text, which will be counted as characters)

    best regards
    25
    1. Tojo
       
      Thank you very much
      0
    2. Pat45
       
      Very clear
      0