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>

[TABLE="width: 360"]
<COLGROUP><COL style="WIDTH: 60pt" span=6 width=80><TBODY>[TR]
[TD="class: xl24, width: 80, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 80, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 80, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 80, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 80, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]31↑[/TD]
[TD="class: xl24, bgcolor: transparent"]23↓[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]31[/TD]
[TD="class: xl25, bgcolor: transparent"]23[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]1↓[/TD]
[TD="class: xl24, bgcolor: transparent"]6↑[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]1[/TD]
[TD="class: xl25, bgcolor: transparent"]6[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]26↑[/TD]
[TD="class: xl24, bgcolor: transparent"]19↑[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]26[/TD]
[TD="class: xl25, bgcolor: transparent"]19[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]2↓[/TD]
[TD="class: xl24, bgcolor: transparent"]3↑[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]2[/TD]
[TD="class: xl25, bgcolor: transparent"]3[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]23[/TD]
[TD="class: xl24, bgcolor: transparent"]2[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]23[/TD]
[TD="class: xl25, bgcolor: transparent"]2[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]2[/TD]
[TD="class: xl24, bgcolor: transparent"]27[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]2[/TD]
[TD="class: xl25, bgcolor: transparent"]27[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]7[/TD]
[TD="class: xl24, bgcolor: transparent"]7[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]7[/TD]
[TD="class: xl25, bgcolor: transparent"]7[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]24[/TD]
[TD="class: xl24, bgcolor: transparent"]32[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]24[/TD]
[TD="class: xl25, bgcolor: transparent"]32[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]41↑[/TD]
[TD="class: xl24, bgcolor: transparent"]54↓[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]41[/TD]
[TD="class: xl25, bgcolor: transparent"]54[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"]9↓[/TD]
[TD="class: xl24, bgcolor: transparent"]3↑[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl25, bgcolor: transparent"]9[/TD]
[TD="class: xl25, bgcolor: transparent"]3[/TD]
[/TR]
</TBODY>[/TABLE]


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.