How to returns a specific number of characters from a text string

Hi, I want to returns a specific number of characters from a text string and I try to use MID and SEARCH formula for first row, but I dont know what to do next for other rows. How can we get the e...

sample_MID.xlsx10 KB

excel

Formulas and Functions

Detlef_Lewin

Aug 21, 2022

littlevillage

=LET(
a,FILTERXML("<y><z>"&SUBSTITUTE(C2," ","</z><z>")&"</z></y>","//z"),
b,--(LEN(a)={11.12.18}),
c,SEQUENCE(3,,1,0),
d,MMULT(b,c),
CONCAT(IF(d,a,"")))

littlevillage

Iron Contributor

Aug 21, 2022

Detlef_Lewin

Thank you for your response

when the first and at the end of text string added characters differently "x". It's show the result in column B

Detlef_Lewin

Silver Contributor

Aug 21, 2022

littlevillage

More SUBSTITUTE().

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"x",""),"a",""),"b",""),"c",""))

Forum Discussion

How to returns a specific number of characters from a text string

Resources