Generating the next column letter via formula
I am trying to grab a Column letter that is written in a cell and then generate what would be the next column's letter. This works for A to Z, but after that, my formula doesn't work
Let's say Cell A1 contains letter A and I want my function to show the next possible column, here B. This works:
=char(CODE(A1)+1)
However, if A1 contains letter Z, I want it to show the next column combination AA. Of if it's AZ, I'd like it to show BA. Is there any formula that can be created to execute this function?
Solution
=SUBSTITUTE(ADDRESS(1, COLUMN(INDIRECT(A2&1))+1, 4), 1, )
- Allow script to edit locked cells
- How to join unique strings in their own column with QUERY?
- How do I use XLOOKUP for multiple criteria?
- How to use AppendRow
- How to code "Next Friday" in Google Sheets?
- How can I resolve this `Error: You must select all cells in a merged range to merge or unmerge them.` while merging cells through App Script?
- Casting method asTextItem throws error for Google form item
- Counting blank cells by arrayformula
- ARRAYFORMULA with GOOGLEFINANCE function
- Conditional formatting depending on two cells
- How do I find the highest sum of multiple cells in column A where the sum is based on multiple cells matching in column B in Google Sheets?
- Returning the last input entry
- Draw and filter Charts in App Script Web app
- Google Sheets - select "most recent " cell in a column and return corresponding value in same row
- Byrow formula with reference to last row and last column
- How Do I Give rows in a table of contents a key. Then look up the key Later using the data from the rows in table of contents?
- Duplicate whole spreadsheet using Google Sheets API
- Array Formula to omit certain values
- Google Sheets Query While Removing Duplicates
- NAME error hiperlink function Apps Script Google Sheets
- Three-dimensional referencing
- Can I use a named range as column headers?
- Trying to get Google App Script Code to Acknowledge Cells In A Column in Excel to do Individual Math
- How to get the price of a stock at a particular date from Google Finance?
- How to Split a String Up into Individual Characters
- How to integrating Google Sign-In into your google script web app
- Formula is currently double-counting a cell
- Get dropdown options in google sheets in table
- Search for targets and indicate where they come from
- One-to-one assignment in Google sheets with data validation