» How to change column number with letter in Microsoft Excel
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
Column number in cell A1: 5 The Function: =IF(AND(A1>0,A1<257),IF(A1>26,CHAR(64+INT((A1-1)/26)),"")&CHAR(65+MOD(A1-1,26)),"") Result: E
Book Store:
Recommended Books:
- Business Plans For Dummies®
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Analyzing Markets, Products, and Marketing Plans
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Accounting for Dummies
No comments have been submitted.
