Forum Discussion
littlevillage
Aug 21, 2022Iron Contributor
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...
- Aug 21, 2022
=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
Aug 22, 2022Iron Contributor
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?
Detlef_Lewin
Aug 22, 2022Silver Contributor
- littlevillageAug 23, 2022Iron Contributor
- HansVogelaarAug 23, 2022MVP
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.
- littlevillageAug 22, 2022Iron Contributor
sorry my friend, i am looking on google and youtube but i could not find how to open the full text Editor in excel.
- Detlef_LewinAug 22, 2022Silver Contributor
Open the full text editor and klick on "Insert code" in the icon bar.
Then choose Language and enter the code.
- littlevillageAug 22, 2022Iron Contributor
I see many member of this forum do it. How can I use it?
- Detlef_LewinAug 22, 2022Silver Contributor
- littlevillageAug 22, 2022Iron Contributor
In regular excel I could not see something the same as this image, that's why I said' where did you write the formula"