the formula =CHAR(COLUMN()+96) only works thru z
is there a formula than works 2+ column letters
Thanks Carroll
the formula =CHAR(COLUMN()+96) only works thru z
is there a formula than works 2+ column letters
Thanks Carroll
What do you mean?is there a formula than works 2+ column letters
What do you want to achieve?
O I understand what you mean.
You want a formula that returns the column reference as a string.
This formula works until zz (for 702 columns)
Please try in A1 and copy rightFormula:Please Login or Register to view this content.
Another optionFormula:Please Login or Register to view this content.
Or this oneIs also working for all columnsFormula:Please Login or Register to view this content.
@Fluff your formula in post #4 returns CS in column A
Last edited by HansDouwe; 06-01-2023 at 03:09 PM.
Your formula will not work for the OP as they are using 2010.
Yes I know, that because the OP was adding 96 to the column number so I did the same.@Fluff your formula in post #4 returns CS in column A
The OP add 96 in the CHAR function, because he wants 'a' in column A and so on.
@Fluff you are right, the formula of post #5 works only in Excel 365 and I also need a SUBSTITUTE.
This formula should work in EXCEL 2007 and newer:Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks