» 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:
- Windows XP Pocket Reference
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Mastering Excel 2000 (for beginner)
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Financial Reporting and Analysis (2nd Edition)
No comments have been submitted.
