فرز رقم موجود داخل خلية تصاعدي وتنازلي #94 - إكسل

=SUM(SMALL(MID($A34;ROW(INDIRECT("1:"&LEN($A34)));1)*1;ROW(INDIRECT("1:"&LEN($A34))))*10^(ROW(INDIRECT("1:"&LEN($A34)))-1))
=SUM(LARGE(MID($A34;ROW(INDIRECT("1:"&LEN($A34)));1)*1;ROW(INDIRECT("1:"&LEN($A34))))*10^(ROW(INDIRECT("1:"&LEN($A34)))-1))