将0字符添加到缺少它的字符。

Prepend the 0 character to the ones that are missing it.

@Rabbit


你好，兔子，

我一直在想同样的路线。但是，我如何把它放在公式中？如果我只是将0添加到它不会工作的一切，并且可能性（搜索和替换或交叉表）的数量是惊人的（1A到1ZZZ）。


我的另一种选择是更改排序顺序（这是可能的）从0123456789abcdef ..到abcdef0123456789。


祝你好运，


Oxydo

@Rabbit
Hi Rabbit,

I was thinking along the same lines. However, how do i put this in a formula? If i just add an 0 to everything it wont work, and the amount of possibilities (to search and replace or crosstab) is staggering (1A to 1ZZZ).

My other option would be to change the sortorder (is this possible) from 0123456789abcdef.. to abcdef0123456789.

Best regards,

Oxydo

你不能改变那样的排序顺序。但你可以抓住前两个字符，检查它是否是数字，如果不是，那就意味着它缺少0个字符，然后在它前面添加。

You can''t change the sort order like that. But you can grab the first two characters, check if it''s numeric, if it''s not, that means it''s missing the 0 character, and then prepend it.