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

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,786
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↓3123
1↓6↑16
26↑19↑2619
2↓3↑23
232232
227227
7777
24322432
41↑54↓4154
9↓3↑93

<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>
 
Last edited:

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,108,805
Messages
5,524,979
Members
409,613
Latest member
Dalex100

This Week's Hot Topics

Top