How to returns a specific number of characters from a text string

[littlevillage]

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

[#2]

@littlevillage 

=TRIM(SUBSTITUTE(C2,"x",""))

[#3]

@Detlef_Lewin 

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

[#4]

@littlevillage 

What exact logic shall be?

Remove specific character from the text;

Remove start of the text till first space;

Something else

[#5]

@littlevillage 

More SUBSTITUTE().

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"x",""),"a",""),"b",""),"c",""))

[#6]

@SergeiBaklan 

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

[#7 · Accepted solution]

@littlevillage 

=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,"")))

[#8]

@Detlef_Lewin 

Thank you

It is working perfectly, a little question please
Where have you create the formula?

[#9]

@littlevillage 

Right here, in my office.

[#10]

@Detlef_Lewin 

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?

[#11]

@littlevillage 

Obviously I used Excel.

[#12]

@Detlef_Lewin 

In regular excel I could not see something the same as this image, that's why I said' where did you write the formula"

[#13]

@littlevillage 

That is due to the formatting of the forum editor.

[#14]

@Detlef_Lewin 

I see many member of this forum do it. How can I use it?

[#15]

How do I ask questions here? Someone help me please. Where do I go to make posts?

[#16]

@Josephine500 

on your right corner click it> go to Excel>Start a new Discussion

[#17]

@littlevillage 

Open the full text editor and klick on "Insert code" in the icon bar.

Then choose Language and enter the code.

[#18]

@Detlef_Lewin 

sorry my friend, i am looking on google and youtube but i could not find how to open the full text Editor in excel.

[#19]

@littlevillage 

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.

[#20]

@HansVogelaar 

yes, my friend,

I see 

Thank you