列表\图书馆计算列(排序) [英] Lists\Library Calculated Column (sorting)
问题描述
我有一个按名称排序并按类别分组的库。但是,文件名与字母和数字混合在一起。如下所示,字母排序没有问题,但数字没有正确排序。我读到计算列可以解决这个问题。
我读了几个解决方案,但我不是一个脚本(公式)和精明。有人可以帮忙吗?
提前谢谢!
示例:
F1
F10
F11
F12
F2
F3
F4
H1
H10
H11
H2
H20
H21
H3
H4
H40
H5a
您好,
您可以创建计算列并按此列排序。以下是供您参考的公式:
= CONCATENATE(LEFT([Title],1),TEXT(MID([Title],2,2)," 00"))
请注意,此公式仅适用于简单字符串。如果列中包含更复杂的字符串,则需要更复杂的公式来满足您的要求。
最好的问候,
Chelsea Wu
I have a library which is sorted by Names and Grouped by Category. However, the file names mixed with letters and numbers. As you can see below, no issue with letter sorting but numbers not sorting properly. I read that a calculated column can fix this issue. I read several solutions but I'm not a script (formula) savvy. Can anyone please help?
Thank you in advance!
Example:
F1
F10
F11
F12
F2
F3
F4
H1
H10
H11
H2
H20
H21
H3
H4
H40
H5a
Hi,
You can create a Calculated column and sort by this column. Here is the formula for your reference:
=CONCATENATE(LEFT([Title],1), TEXT(MID([Title],2,2), "00"))
Please note this formula only applies on simple strings. If the column contains more complicated strings, you will need more complex formula to achieve your requirement.
Best regards,
Chelsea Wu
这篇关于列表\图书馆计算列(排序)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!