Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Nou pe simpatie:
Alexandra21

Femeie
24 ani
Calarasi
cauta Barbat
24 - 53 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Formula to Display the Letter of the Current Column

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 960

=SUBSTITUTE(ADDRESS(1;COLUMN();4); "1"; "")

This works by using the ADDRESS function to return the address of the current column (e.g., "$A$1"), and then SUBSTITUTE removes the row number, leaving just the column letter.

Source: ChatGPT

Pagini: 1

Mergi la