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 21, 2022Iron Contributor
I want to separate the tracking number from the text string and its length11, 12 or 18 characters
sometimes it's at the beginning, middle or end of the string text
the expect result shown in column A
Detlef_Lewin
Aug 21, 2022Silver Contributor
=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,"")))
- littlevillageAug 22, 2022Iron Contributor
Thank you
It is working perfectly, a little question please
Where have you create the formula?- Detlef_LewinAug 22, 2022Silver Contributor
- littlevillageAug 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?