Spreadsheet display column letters

Display spreadsheet column letters using the following formula:

=REGEXREPLACE(ADDRESS(ROW(), COLUMN(), 4), "[[:^alpha:]]", "")

Comments

Leave a Reply