Forum Discussion
How to returns a specific number of characters from a text string
=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?
That screenshot is not from Excel but from this forum.
In Excel you can expand the formula bar by pressing Ctrl+Shift+U.
And you can insert line breaks in a formula by pressing Alt+Enter.
sorry my friend, i am looking on google and youtube but i could not find how to open the full text Editor in excel.
Open the full text editor and klick on "Insert code" in the icon bar.
Then choose Language and enter the code.
I see many member of this forum do it. How can I use it?
In regular excel I could not see something the same as this image, that's why I said' where did you write 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?
