Forum Discussion
Solved
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,"")))
