使用Excel中的数字排序链接 [英] Sorting of links with numbers in Excel
本文介绍了使用Excel中的数字排序链接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要对列表进行排序,如
* _ 1013
* _100
* _14
(第一个4位数的链接,然后是3位数,然后是2位数字)
Excel中是否有可能以正确的方式对这个数组进行排序? p>
解决方案
从您的问题,* _ XXX
串。所以要获得你需要的价值
- 识别
* _
发生在哪里,提取 - 从提取的字符串中删除
* -
(我使用SUBSTITUTE
做),然后将其转换为值
= IFERROR(VALUE(SUBSTITUTE(RIGHT A1,LEN(A1)-FIND(* _,A1)-1),* _,)),不匹配)
I have a list of similiar links of website with equal base in Excel. At the and of the link there is numbers, e.g. *_100, *_1013, *_14 and so on.
I need to sort the list descending like
*_1013
*_100
*_14
(first 4-digit links, then 3-digit, then 2-digit)
Is there any possibility in Excel to sort this array in right way?
解决方案
From your question the "*_XXX"
is at the end of the string. So to get the values you need to
- Indentify where the
*_
occurs and extract that - Remove the
*-
from the extracted string (which I usedSUBSTITUTE
to do), then convert it to a value
=IFERROR(VALUE(SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("*_",A1)-1),"*_","")),"no match")
这篇关于使用Excel中的数字排序链接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文