Excel: extract the text after a character.
Solved
lolo5476
-
Pat45 -
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
Thank you.
I bet on chocolate that I would find it, but I've been at it for 30 minutes already.
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
Hello
for a text in A1
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
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
Tojo
Thank you very much
Pat45
Very clear