Extract text

[Inacio11]

Hi Masters
Could you please help me on issue below ? I need a formula to get "Result 1" and "Result 2", as follow:
Result 1: I need to extract just part of text as shown
Result 2: I need to get as result only a row that have the same letters from the range Int1 ~ Int5 (empty/blank cells should not be consider )
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Result 1[/TD]
[TD]Int1[/TD]
[TD]Int2[/TD]
[TD]Int3[/TD]
[TD]Int4[/TD]
[TD]Int5[/TD]
[TD]Result 2[/TD]
[/TR]
[TR]
[TD]C 440 LA6x2MNA[/TD]
[TD]6x2[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]A 250 LB6x2MSA[/TD]
[TD]6x2[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]B[/TD]
[TD][/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Y360IB4X2 N B[/TD]
[TD]4x2[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]F 440 CA6x4ESZ[/TD]
[TD]6x4[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]check[/TD]
[/TR]
[TR]
[TD]T 440 LA8x2/4NMA[/TD]
[TD]8x2/4[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]P310UB6X2*4 L B[/TD]
[TD]6x2*4[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD]check[/TD]
[/TR]
[TR]
[TD]W 360 LA4x2MSZ[/TD]
[TD]4x2[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N/A[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]check[/TD]
[/TR]
[TR]
[TD]R 320 UB6x2*4LB [/TD]
[TD]6x2*4[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]C LB6x2MNA[/TD]
[TD]6x2[/TD]
[TD][/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]check[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance !
Inacio

 

[sheetspread]

This worked on your sample:

Excel 2010
	A	B	C	D	E	F	G	H
1		Result 1	Int1	Int2	Int3	Int4	Int5	Result 2
2	C 440 LA6x2MNA	6x2	A	A				A
3	A 250 LB6x2MSA	6x2	B	B		B		B
4	Y360IB4X2 N B	4x2	A	A		A		A
5	F 440 CA6x4ESZ	6x4	C	D		C	C	check
6	T 440 LA8x2/4NMA	8x2/4		B	B		B	B
7	P310UB6X2*4 L B	6x2*4	D	D	N/A			check
8	W 360 LA4x2MSZ	4x2	D	D	N/A	D	D	check
9	R 320 UB6x2*4LB	6x2*4	C	C	C	C	C	C
10	C LB6x2MNA	6x2		D	A	B		check
Sheet9 (2)

Cell Formulas
Range	Formula
B2	{=LOWER(MID(A2,SEARCH("x",A2)-1,3+(SUM(--ISNUMBER(SEARCH({"/","~*"},A2)))*2)))}
H2	{=IF(SUM(IFERROR(1/COUNTIF(C2:G2,C2:G2),0))=1,INDEX(C2:G2,MATCH(TRUE,IF(C2:G2<>"",IF(C2:G2<>"N/A",TRUE)),0)),"check")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[sheetspread]

(column B also works without ctrl-shift-enter)

 

[Inacio11]

Thanks sheetspread !!