» 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:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Accounting the Easy Way
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The Fall of Advertising and the Rise of PR
- Microsoft Excel Version 2002 Step by Step
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
No comments have been submitted.
