» 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:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The One Page Business Plan: Start With a Vision, Build a Company!
- Investing in Real Estate, Fourth Edition
- Analysis of Financial Statements
- Microsoft Outlook 2002 for Dummies
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
No comments have been submitted.
