以列“AA”返回列字母而不是数字。向前 [英] Return the column letter rather than number with column "AA" onwards

问题描述

我使用
= CHAR（COLUMN（A1）+96）

要返回列的字母，这在上面的例子是罚款。

但是，一旦列超出 Z 到 AA 等等，列字母将不会正确返回。

我明白为什么，因为它已经达到了字母集的结尾，超出了其他字符。

是否有另一种方法来准确地返回列字母？

解决方案

获取列信的替代方法：

  = SUBSTITUTE（ADDRESS（1，COLUMN（A1）+26,4,1），1，）
  

但是，正如Scott已经指出的那样，根据需要，可能有更好的方法来实现你的最终目标。 p>

I am using =CHAR(COLUMN(A1)+96)

To return the column letter, which is fine in the instance above.

However, once the column goes beyond Z into AA and so on, the column letter will not return properly.

I understand why, as it has reached the end of the alphabet set and beyond that are other characters.

Is there another way to accurately return the column letter?

解决方案

Alternate method of getting the column letter:

=SUBSTITUTE(ADDRESS(1,COLUMN(A1)+26,4,1),1,"")

However, as Scott has already pointed out, depending on the need, there is probably a better way to accomplish your end goal.

这篇关于以列“AA”返回列字母而不是数字。向前的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！