» 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:
- Microsoft Excel VBA Programming for the Absolute Beginner
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Special Edition Using Microsoft Word 2002
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Accounting for Dummies
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
No comments have been submitted.
