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 expect result
Thank you
=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,"")))
- How do I ask questions here? Someone help me please. Where do I go to make posts?
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
More SUBSTITUTE().
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"x",""),"a",""),"b",""),"c",""))
