How to Ignore Left Side and then Divide Remaining Characters in Half

[rebel123]

Thanks for your help.
Need an equal sign equation please.

easyupload.io

easyupload.io

easyupload.io

 

[rebel123]

Enclosed is the screenshot. As you can see, I am trying to get rid of the word "Select"
and the space. And then, depending on how many characters are left, I only want
half of them (in order) left.

So, for example, here are other examples

SELECT BBBABBBA (Correct answer is BBBA)
SELECT VYYXXVYYXX (Correct answer is VYYXX)

 

[Fluff]

How about

=LET(a,TEXTAFTER(A1," "),LEFT(a,LEN(a)/2))

 

[Peter_SSs]

Based on your sample data, also

=MID(A1,8,(LEN(A1)-7)/2)

 

[rebel123]

Thanks Fluff and Peter. I tried Fluffs formula and works perfectly!

 

[Fluff]

Glad we could help & thanks for the feedback.