Formula to return the column letter for any cell.
=SUBSTITUTE(ADDRESS(1,COLUMN(E3),4),"1","")
This formula will produce the result: E
Formula to convert a column letter into the column number:
=COLUMN(INDIRECT(CONCATENATE("E","1")))
This formula will produce the result: 5
Subscribe to:
Post Comments (Atom)
-
I recently became interested in amateur rocketry when I discovered Richard Nakka ’s Experimental Rocketry Web Site . After studying the site... -
by Agnes Romie Johnson Meckfessel (also available in PDF ) History records that in 1658 the extreme Southern part of Sweden was released fr...
-
Many good meaning people are adamantly in favor of government run healthcare. In fact, social media is chocked full of quotes and thoughts f...
No comments:
Post a Comment