Considering Specific Alphanumeris characters in Cell

[shansakhi]

Hi All,
Can you please assist for below.
I have below data sepearted by "-". There are thousand of rows.
I want all the 2 alphanumeric codes except W2 as output... only2 alphanumeric

Routing (Input)	AL (Output)
MJ-W2-W2-W2-W2-MJ	MJ MJ
ET-ET-W2-W2-W2-TF	ET ET TF
W2-W2-TF-MJ-W2-W2	TF MJ
CO-W2-W2-V-W2-CO	CO CO
CO-V-W2-V-TF-W2	CO TF

 

[Fluff]

How about

Fluff.xlsm
	A	B
1	Routing (Input)	AL (Output)
2	MJ-W2-W2-W2-W2-MJ	MJ MJ
3	ET-ET-W2-W2-W2-TF	ET ET TF
4	W2-W2-TF-MJ-W2-W2	TF MJ
5	CO-W2-W2-V-W2-CO	CO CO
6	CO-V-W2-V-TF-W2	CO TF
Data

Cell Formulas
Range	Formula
B2:B6	B2	=LET(s,TEXTSPLIT(A2,"-"),TEXTJOIN(" ",,FILTER(s,(s<>"W2")*(LEN(s)=2))))

 

[shansakhi]

Thank you so much it is working as desired.

 

[Fluff]

You're welcome & thanks for the feedback