Extract values "before after up down arrow" or "not arrow"

[motilulla]

Hello,</SPAN>

I need to get result show only values in any condition weather they are "before after up down arrow" or "if there is no arrows"</SPAN></SPAN>

Example....</SPAN></SPAN>

	31↑	23↓		31	23
	1↓	6↑		1	6
	26↑	19↑		26	19
	2↓	3↑		2	3
	23	2		23	2
	2	27		2	27
	7	7		7	7
	24	32		24	32
	41↑	54↓		41	54
	9↓	3↑		9	3

<COLGROUP><COL style="WIDTH: 60pt" span=6 width=80><TBODY>
</TBODY>

Thank you all</SPAN></SPAN>

Excel 2000</SPAN></SPAN>
Regards,</SPAN>
Moti</SPAN></SPAN>

 

[Tetra201]

Try

=SUBSTITUTE(SUBSTITUTE(B4,"↑",""),"↓","")

 

[motilulla]

Try

=SUBSTITUTE(SUBSTITUTE(B4,"↑",""),"↓","")

Tetra201, it worked as appeal! Thank you so much for your kind help!</SPAN></SPAN>

Kind Regards,</SPAN></SPAN>
Moti </SPAN></SPAN>

 

[Tetra201]

You are most welcome.