Forum Discussion
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...
=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,"")))
=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,"")))
Thank you
It is working perfectly, a little question please
Where have you create the formula?
Hi Detlef,
Sorry for my english
I am just start with excel about 4 months
I mean, What did you use to write the formula?